Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
srikale
Starting Member
2 Posts |
 Posted - 2009-10-15 : 11:15:37
|
| Hi All,I am working on one SSIS package. Since few days I am fighting with this problem. I am using OLEDB command Transformation in Data flow. This OLEDB Command will call the Master Stored Procedure with input parameters. The master Stored Procedure is calling one Child stored procedure using linked server. The child stored procedure will insert the record based on master stored procedure input parameters.The weird thing is whenever I click on any transformation it is making blank entry in target linked server table.No clue what to do. Any suggestions pleaseThank you,Srini |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-10-15 : 11:27:23
|
The OLE DB Command in the Data Flow Transformation executes an SQL command for each row in a dataset.Is this what you require?quote:
The weird thing is whenever I click on any transformation it is making blank entry in target linked server table.
What do you mean by this? In design mode? When the package/task executes?Did you run Profiler to see what commands are running? |
 |
|
|
srikale
Starting Member
2 Posts |
Posted - 2009-10-16 : 09:25:28
|
i fixed the issue 90%, the problem is, the property "validate External MetaData" needs to modify to false. still its inserting a blank record when i run my package. text file is good, no blanks, currently working with microsoft ticket. Thank yousriniquote:
Originally posted by YellowBug
The OLE DB Command in the Data Flow Transformation executes an SQL command for each row in a dataset.Is this what you require?quote:
The weird thing is whenever I click on any transformation it is making blank entry in target linked server table.
What do you mean by this? In design mode? When the package/task executes?Did you run Profiler to see what commands are running?
|
|
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-10-16 : 09:49:01
|
| Ok. Please let us know what the solution is, when you have one.Thanks |
|
|
|
|
|
|
Problem with OLEDB command Transformation