[font="Comic Sans MS"]

A nice third party tool from redgate (a sponsor of SSC as well) to provide a lot more features with visual aid and obtaining schema definition :

http://www.red-gate.com/products/SQL_Dependency_Tracker/index.htm

I love...

[font="Comic Sans MS"]

Also - you can check this on google online book:

http://books.google.com/books?id=N7tzbajkNccC&pg=PT198&lpg=PT198&dq=%22Use+a+DataReader+when+consuming+or%22&source=bl&ots=NDeIXy6Qhg&sig=tk9QEX6uUvVbBYOHmTc29CnEnZU&hl=en&ei=WDg6S6GHGI-0NpSZlLsH&sa=X&oi=book_result&ct=result&resnum=1&ved=0CAgQ6AEwAA

[/font]

[font="Comic Sans MS"]

Anamika - you can check this out:

http://support.microsoft.com/default.aspx?scid=kb;en-us;925068&sd=rss&spid=2855

[/font]

[font="Comic Sans MS"]

Check this : http://www.mssqltips.com/tip.asp?tip=1585

[/font]

[font="Comic Sans MS"]

Probably being used as a surrogate key?

[/font]

[font="Comic Sans MS"]

^^ Correct.

Also you wouldn't want to hardcode something like database names in the script task -

as new databases may be added or dropped.. 😎

[/font]

[font="Comic Sans MS"]

That's strange - it should work.

Can you use data viewer and see if your variable vision_gorr_data is coming as row-by-row?

Will check myself (unfortunately no time right now) and...

[font="Comic Sans MS"]You already asked 😛 ...

I was more...

[font="Comic Sans MS"]

The only additional thing I did was to define a variable user::fileJustFound (string).

On for each loop container -> variable mapping -> mapped user::fileJustFound as 0 (the only one...

[font="Comic Sans MS"]

Works fine for me.

How are you trying to access the variable from the object? Did you define another variable and mapped in for each loop?

[/font]

[font="Comic Sans MS"]

You may alternatively use conditional split - check this out

http://filedb.experts-exchange.com/incoming/2009/02_w06/102596/Working-with-Flat-Files-in-SSIS.pdf

[/font]

[font="Comic Sans MS"]

As Phil has already mentioned - you can not just mix and match the columns here.

From my understanding - you just want those 2 datasets to be literally...

[font="Comic Sans MS"]

Also - it might be a good idea to use a handy plugin - BIDS helper that highlights variables and connection managers driven from configuration file.

[/font]

[font="Comic Sans MS"]

Hello there -

unfortunately it's extremely difficult to identify which step you are doing wrong. Please refer the step by step procedure below and see if this still doesn't...

[font="Comic Sans MS"]

Cool - great to know it worked. [:)]

[/font]