Running a package from .NET code can be found here:

http://msdn.microsoft.com/en-us/library/aa337077.aspx

Yes this is possible. Just use a data flow task with a flat file souce and a flat file destination.

I think it depends how you are running the ssis package. If you are running it via a proc or job then I believe it will run under the sql...

A friend got a response to this question on the msdn forums in case anyone is interested:

http://forums.microsoft.com/msdn/ShowPost.aspx?siteid=1&postid=3826161

Please provide more details. What does the table look like? Same number of columns and datatypes as the file? etc... Also why do you need to use ssis? BCP can...

'oxfield':

I wouldn't even bother trying to work with the ssis object model for something like this. It's very annoying and not worth the effort. BCP seems to be a very...

As already suggested, use the bcp command line utility to generate a format file for you. I recommend using the xml format file is possible.

Command:

C:\>bcp DatabaseName..TableName format nul -T -c...

You just need to call the stored procedure as normal and then inspect the command object for the appropriate output parameters. You can then get their values.

You don't need ssis for this at all. One option is to create a scheduled task in Windows to do what you want. Another option is to create a job...

For those interested, here is a page that describes how to use BCP to import data where the source file columns are in a different order to the target table...

Crispin Proctor, you said:

"You could do it with BCP but your table columns / file columns will have to be aligned".

Are you sure of this? I thought that's exactly what...

Bulk insert task to load the file into the table, then a script task to examine the table and take actions?

Or if you don't need ssis at all, then BCP...

I believe this post is in the wrong forum but you're probably after the DATEDIFF function.

e.g.

DATEDIFF(d, @thisdate, @nextmonth)

Perhaps you can loads the file into an object variable at the start of the package and use the variable from then onwards.

Yeah it's better to create a connection manager and then use that in the script task.

Something like this

'Get the connection manager we have created in the package

Dim mConn As SqlConnection...