Hi,

I have changed the authentication mode of my sql server.

earlier it was selectd as "Windows Authentcation".. have changed it to SQL Server and Windows Authentication Mode...

Thanks a lot..

my problem got solved now:):)...

Hi,

Many thanks for your help.

But if I am specifying DBO as schema of this store proc, who all users will be able to access this?

and If I specify my own...

Hi,

I am not using any code or script for this. I am trying to import multiple files for a folder using for eachloop container.

Thanks, everything is clear now.

Thanks a lot, this has solved my problem...

Hi,

Data flow task I have successfully added, but now getting error on FTP task.

While executing package it's giving error: Flat file connection manager is not a file."

In FileTransfer :Flat file...