Phil/Divyanth,

Yes, delimiter was the issue. The package has:

Header row delimiter: {LF}.

Row delmiter: {CR}{LF}.

Column delimiter: {|}.

I was able to upload all rows by adding extra {|} at the end of each...

Lutz,

Since # of column in file does not match with # of column in staging, BULK INSERT failed.

Phil/Divyanth,

Here are first 4 columns (20 actual) of row in flat file:

USER|STATUS|CLASSID|CLASSNAME

CGDXERA ...

Hi Lutz,

Thanks. My guess I don't have that option. It is production SSIS and was told to fix the issue.

Chris

John,

Thanks a million. It works.

I can now focus why it could not write CSV attachment.

Chris

John,

Thanks for the help. Inside ForEach Loop, it tuncates, upload, process, write attachment (with Data Flow Task), send email with attachment and finally move file to Archive folder. It failed...

Hi Elliott,

Yes, it makes sense to me.

The package cut/paste csv files from web to SQL server for processing. After adding SQL Agent to web folder, I was able to...

Hi Elliott,

Thanks for helping out.

Yes, one of my colleague opened dtsx thru VS and confirmed package was configured with XML. However, I found later there were 2 warning messages in...

John,

Thanks for the help.

SSIS move files from 5 application to SQL servers, check file name, header, load into staging and start processing rows (creating rows few different base table). You...

Hi CozyRoc,

Thanks for helping out. It was spreadsheet heading. User uploaded file with 'PHASE'; package could only take 'Phase'.

I did not it is case sensetive. Also error message was very...

John,

Thanks for helping out.

QA granted me the rights to run package. I copies the file worked fine on dev to QA and ran the package. No error but stop processing...

Hi,

Thanks for helping out. Sorry I did not make question clear.

I am trying to make package easy to deploy from development, QA and then to production. I created a row...

The one I had was first set SQL folder for FTP file, FTP task, upload file into staging table, SQL task to execute procedure (copy staging to permanent table) and...

Hi Sharon,

There is no need to install FTP service on SQL box. The reason I could not FTP and copy file was that I had extra folder at end FTP...

Hi Matt,

Yes, that works. Thanks million!

Chris

Hi Matt,

Thanks for help. I have something like:

select a

b,

c,....

from tbl1

inner...