Can I send u my file..

Shaun

no it is on the last line..

Is the missing row the first, a middle or the last line? last Line Missing

Is it trying to read one line as a header? im using header rows to skip...

I also deleted 5 rows..and it always showing 1 row less..

Shaun

Hi Koen,

I had checked the structure looks good..any other way to identify the issue.

Shaun..

HI KEITH,

WHERE TO USE THE EXPRESSION, IM quite new to ssis.

As the name changes but only the date changes:

Date = SUBSTRING(name,1,FINDSTRING(name,"_",1) - 1)

File name = SUBSTRING(name,FINDSTRING(name,"_",1) + 1,100)

For...

HI Keith,

Yes i am doing in SSIS,

Reagrds

Shaun

I will do it, let you know any issues occur, but thank you so much for you help and going thoroughly..

Regards

Shaun

I saved the passwords in the package and encryption: EncryptSensitive with user key..

Regards

Shaun

Forgot to mention using oracle 11g as well

Hi Andrew,

I'm using SQL 2008 r2, both in prod and dev.

I am using XML config file.

My project has 5 packages.

I updated all the passwords but when I reopen, I get...

i am geting lost no idea how to do it.. im new in it..

can i send an e-mail with the issue. I do have a packaage alaready existed but it has to be done for 2 more files but name changes.. so...

Hi Dan and Alvin,

I want to copy ther files from a folder and delete the files after moving in it

ex:

Folder A: abc.txt

Folder b:

Now copy from from folder a to...

Im still not getting how to do it..

im lost when using import

im using ssis 2008