I was resistant to using staging tables at first, but later realized they can be the right tool at times.  I have approached similar tasks by loading a staging table...

Could you use a lookup, and craft the query of [200_CGDS_VALIDATION].[dbo].[Vali_Data] such that you could use @[User::TMC_Ident_From_Filename] as the input column?

This may give you an idea to get started if you don’t have too many unique file layouts to deal with.  I had a similar situation where there were three...

You didn’t say where you are pressing the Add button, but in general, the way to redirect error output from an OLE DB destination is to open the editor and...

You might have to fix this type of error on a column by column basis.  I haven’t been working with SSIS very long, so there is likely a better way,...

I had this happen to me a while ago.  The circumstances were a bit specific, so it’s likely not causing your problem, but just in case.

In...

I'm an idiot.  This is an SSIS forum, right?   I saw your question and thought SSRS.....not sure why.

Sorry for the misdirection.

I was forced into research mode when I implemented this functionality as customization to a commercial asp.net application.  If you’re doing straight asp.net, it should be a bit simpler.   What...

You select the location when you create the configuration. Configurations are tightly bound to package variables and I spent a fair amount of time getting a handle the big picture. ...

We use an XML Configuration File in our packages to set the database server and name.  There’s probably a better way if you can use the project deployment model, but...

Several folks that have encountered this error found it started occurring after a VS update.

Google this, and take a look at the first several hits:

ssis "Scripts...

I created a stripped down package and isolated the issue to assigning a Streamwriter to an SSIS object variable in a script task:

Dts.Variables["User::OBJ_LOG_WRITER"].Value = SWriter; 

If...

Thanks guys.

I don't understand your response, I didn't ask the right question, or I didn't create the flat file connection properly.

I do know what the flat file data is,...

Thanks Phil.

I did find a workable solution.  I fed the output from the OLE DB data source into a Multicast transformation, which will clone the results as many...