SSIS Help Please

[Pho3nix]

Hi all,

I have an issue with a test package I am working on.
Logic seems sound but no data is coming out on the other end.

Basically I load up a table of data.
Save the result set to an object variable.
Use a ForEach Container to point certain column's to new column variables.
Add a data flow task.
Create a script task wherein I create a new output row for each line in the object.
Use the output as a source to input into a OLE DB Destination.

^_^ Sounds right in my head but all the values I get in the destination tables are null BUT to the correct count of rows I receive from the data set.

Anyone have some experience with this? Can expand where needed.

 

[shauntir]

Do you need to access each source row as an indexer? All data columns are of the right type?

Only have some experience with SSIS so just throwing out some suggestions...

 

[Pho3nix]

Do you need to access each source row as an indexer? All data columns are of the right type?

Only have some experience with SSIS so just throwing out some suggestions...

All columns are the correct data type.
And don't need to access them that way but lemme toy around and see, might be the problem.