Hi

Yes, it works since 2008 R2, Let me check how I did it on SQL 2005 version, I had to dig out some

older projects.

Br.

Mike

Hi, Imho you can use the Lookup() or Lookupset() functions to retrieve data from two datasets based on lookup keys.

Br.

Mike

Hi

I'm afraid not, you can count rows in separate tasks before and after run Bulk Insert Task.

Br.

Mike

Hi Saikumar

Please try out my package (connection string change required),

it's from SQL 2012 but should work fine.

Br.

Mike

Hi

Try to play around with those parameters: DefaultBufferMaxRows and DefaultBufferSize,

set smaller values.

Br.

Mike

Please tell me what element you have inside the Foreach Loop Container?

Try to cast to nvarchar(4000) in SQLStatement of Execute SQL Task instead of max (SSIS doesn't love it).

Best regards

Mike

Hi

I'm afraid the problem is occurring that conversion is not possible in ForEach Loop when dealing with object variable as enumerator. Please try to convert before inserting into the...

Hi

I've got very similar scenario, users put the archive files on ftp with random names,

so Process Task launches a batch file which extracts file and renames as defined in connection...

Oh Man, I haven't touched the clipper for ages. What kind of OS have you got?

If it is Win7 please check first config.nt and try to add files=200 and...

Hi

Please take a look for link:http://winscp.net/eng/docs/guide_ssis#ssis_task. Imho

it is much a better solution than the built-in FTP Task.

Regards

Mike

Hi Joe

As I remember you can do the autocomplete featrue by AJAX Style.

Best regards

Mike

Hi

I've got a similar solution but I don't create a new one. The File Task copy an empty from repository.

Imho it is the simplest way.

Best regards

Mike

Hi

I'm not sure that I undestood your post, Imho if it is only 1 character wide, please set NCHAR (or even CHAR for non-unicode) instead of NVARCHAR, it needs 2...

Hi

Let me clarify, you run the job on server A (SSIS instance) that calls the package on sever B.

It will be a bit more time consuming to rewrite the package...

Hi Jose

Please check this out: http://stackoverflow.com/questions/6298806/how-do-i-programmatically-get-the-list-of-ms-access-tables-within-an-ssis-packag

There's already been an extensive discussion about similar problem there, hope it can help with your case.

Br.

Mike