[font="Comic Sans MS"]

Can you be more specific on the workflow? Are you using sql query/sp anywhere or integration service components all the way?

[/font]

[font="Comic Sans MS"]

Are you sure the connection being resolved properly and the statement is being executed at all? You can see the progress of the particular component and get an...

[font="Comic Sans MS"]

Alternatively - you can send the output to a flatfile destination (a comma separated file) and mail the file as an attachment.

[/font]

[font="Comic Sans MS"]

Just in case someone needs this - it a simple join but took a while for me to find the tables. Also query this uses old 2000 system...

[font="Comic Sans MS"]

Sorry Jibbara - I tired to go through the the statement few times and got lost somehow. Probably my bad ..

Could you try to elaborate with some data...

[font="Comic Sans MS"]

Yes ... I am using 3 level of package hierarchy and performancewise it has been absolutely fine...

[/font]

[font="Comic Sans MS"]

Yes - you can actually run this. Also this is the reason I asked if you have tried the approach at all. I bothered to write hoping you...

[font="Comic Sans MS"]

Did you at least try?

[/font]

[font="Comic Sans MS"]

This is strange. I am stuck here too - came across this codeplex project and very much interested to try this out.

After importing a simple package - I...

[font="Comic Sans MS"]

You can use forEachLoop container for this. Assign the enumerated value of the field to an user defined SSIS variable - generate the recordset using the query -...

[font="Comic Sans MS"]

You can use conditional split to limit the recordset.

If you are using any surrogate key - like starting from 1..3000000 .. you can use that

or you have...

[font="Comic Sans MS"]

Sorry - I am unable understand the problem you are facing here.

Are you looking forward to optimize your Exec SQL task?

If yes - how long does it take...

[font="Comic Sans MS"]

Here is a quick and excellent reference :

http://www.sqlis.com/post/The-Execute-SQL-Task.aspx

[/font]

[font="Comic Sans MS"]

CSV files are for tabular representation of data - not for text highlighting. It's equivalent of : select * from tablename ...

If you need your data to...

[font="Comic Sans MS"]

wildcard *.csv should work.

Please have a look at the link below and see if you are doing something wrong.

http://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx

[/font]