[font="Comic Sans MS"]This is an excellent question - and as usual I do not have answer to this . May I add a little more here to the question:

Can type...

[font="Comic Sans MS"]You can have two execute sql tasks - one for success path and one for failure (from FTP task). These execute sql tasks will insert the required log...

Can you please explain the scenario in detail?

Thanks Tim for the heads up. Yes - it was my wrong understanding of delimeter and text qualifier. As you suggested to doesn't matter if "" qualifier is not present...

The best possible online resource (other than BOL):

http://consultingblogs.emc.com/jamiethomson/

http://www.sqlis.com/

I think this can be done. But there should not be any dependency between the FTP job and the file creator job. That is - they should be asynchronous.

I assume...

Tim,

Sorry I missed your reply somehow. I will check this out and let you know.

Maybe it too let to acknowledge - but better late than never. Thank you - it worked.

Yes - the Delay Validation property here needs to be set true. This will prevent the compiler to derive the value of the variable (here path/filename etc) till runtime and...

Hi - one option could be something like this:

1) Declare a string variable (user::filename) within the scope.

2) Use a for each loop container to get the actual filename(as this is...

Thanks guys 🙂

@tim-2 : It's not a business requirement - more of audit requirement that each load (identified by an unique loadId) would process only a single file...

Hi Tim/Others,

Similar problem here. I am on VS2005 and unable to open the sample packages.

My situation here is recordset with wrong delimeter: example

"AAA","BBB","CCC","","DDD",,"EEE

...

...

That is the 6th field comes as...

Thank you Andy - will try this out ...

Any help on this guys ...

Which data modeling tool are you using? Use any good tool like ERWIN and use option of forward engineering to get your database creation script. The reverse option is available...