Hi,

There have been discussions on this forum and other places about configuration and package encryption levels. Ultimately it is down to you and your client how you chose to implement...

Hi Cory,

Probably the easiest way to achieve this would be a script transformation component.

In the script component editor, add a column to the output.

In the script designer, try something like...

Hi folks,

I haven't read in detail everything thats been said in this topic, but here is what I do to set the FTP password at runtime. I store the password...

I think you were going down the right track with your eventhandler. Use the OnError event and change the variable [@system::propagate] to FALSE. This should suppress the error so that...

Hi,

There are supposed to be double slashes. This is because "\" is an escape character. My apologies, I forgot that this happens. If you copy that path and replace each...

Reboot!!! It usually works for me!

It sounds like a typo.

Try putting in a breakpoint post execute the filesystem task. While its still in debug mode, open the locals window and find out exactly what is...

My apologies, I missed this post when I replied to your last.

In order to dynamically set the file path you need to specify a variable for either the source path,...

If you explain a little more about what you're trying to do, we might be able to help. Also the integration services forum has a bigger audience for this kind...

How about using the unpivot component?

Hi ital

My current problem is that when I Redirect the error rows, the error description is not written to the log when I select the "OnError" event (in the log...

Hi,

I'm not sure if this step is necessary as from the sounds...

Hi,

Use a dataflow OLE DB Source to execute the stored procedure. Add to the pipeline a derived column component and add a new column which will replace the problem datetime...

The onError event that you have created on the dataflow task will have a system variable called "propagate". You can either set this manually or dynamically using an expression.

This variable...

I agree, I think that you'd have to perform a work around... steps would be something like:

1. Import to a temp table

2. Manipulate the records in the temp table

3. Export...