Never seen that problem occur :/ Sorry

Are you sure the connection string that you're using is valid?

I have a similar package which I use to dynamically send the results of an SSIS package execution to different...

Are you referring to the connection manager for the Flat File or for the OLE DB?

The OLE DB Connection Manager doesn't have an Advanced tab with Data Types, so I...

Your best bet is to just use a stored procedure and run it either directly in the database or through an execute SQL task.

There's no reason to use SSIS for...

There's lots of things you can try.

First, make sure your code is all optimised. That means, your SQL query that is loading the data only takes in the fields you...

you want to load the last 7 files which correspond to the two file names you mentioned?

take a look at this thread. it gives you the general idea that...

If you select your variable and then go to the properties window, you'll see it. Check this screenshot for more details

I'd really strongly recommend that you instead do the processing using SSIS components. That's the whole point of using SSIS 😛 Pretty much everything you could do with the script...

You want to change your variable to use an Expression, and then use the GETDATE() function to get the current date. As it stands you're hardcoding a variable and always...

You're connecting to a SQL Server database? Just use the OLE DB Source as your component and follow the on-screen steps to connect, then use the SQL Command option as...

The first set of errors aren't too important, though you usually should deal with them by putting in a data conversion task and fixing the inconsistencies.

The last one definitely should...

The only way you can do it is to use the SQL Command option and update the rows one at a time. That's a really ugly solution though, especially if...

The simplest solution, as far as I know, is to just not use the fixed width delimiter when doing your import.

I assume you have linebreaks as your row delimiter right?...

Try executing it like this:

DECLARE @DTExec VARCHAR(500)

SET @DTExec = 'dtexec /FILE "[file path]" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING E'

-- Insert statements for procedure here

EXEC...

Directly from the .NET application?

I usually do it by having the DTEXEC command run through a stored proc so I can keep all SQL-related stuff in the database, but...