I have adapted you script slightly to get the 20th day of the current month. I hope I have understood this correctly.

[font="Courier New"]select

case

---if the 20th day is on a...

An idea if I understand this correctly....you could probably do this via javascript.

You could try to embed a javascript function within the report which does the redirection based on a...

I have tested the ODBC connection using a ODBC test utility which enabled me to connect to my Informix ODBC dsn and run the query in the data flow task....

This sounds like a problem with your Oracle client configuration. I'm no expert with Oracle but I kow that if you Oracle client isn't right your SSIS isn't going to...

Can you give more info? Any error messages?

Does the 'Test connection' work in the Oracle ODBC configuration?

I found another post online which shows the exact same issue but provides a couple of images which show the problem.

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/af4b3294-bcaa-4d9d-944a-a8e039895d35/%5B/url%5D

Unfortunately there are no suitable suggestions on this post so...

Your first step would be check to see if SQL Server Authentications is enabled on your server.

Right click on the server in Management Studio -> Properties -> Security and check...

You are probably better using the UNC path (ie \\machinename\sharename) to your folder on the network that contains the access db rather than using mapped drives. Remember that mapped drives...

Hi,

I believe the OLEDB provider Excel is 32bit and your problems is related to this because any 64bit application won't be able to use it.

You are running the 32bit version...

Just in case you hadn't noticed you have your slashes the wrong way around on the UNC.

//123.456.789.123/Upload$\File2.txt

ie

\\123.456.789.123\Upload$\File2.txt

Hi,

Have you added the name of the package variables you wish to set within the script task into the ReadWriteVariable property of the script task?

Regards

Daniel

Hi John,

I think everybody hits this issue at some point when deploy their packages. The only option under PackageProtection which I have found useable is the DoNotSaveSensitive. I just did...

Looks like you are going to have to test them to see which event it appropriate. I would look at OnExecStatusChanged first. There are also package system variables called Cancel...

Hi John,

This makes perfect sense now. In there is a ProtectionLevel property which by default (I think) encrypts the sensitive data (ie passwords) with a user specific key. The package...

Hi,

This is probably a security problem. When you run the DTS from the command prompt it will run under your user account. When you schedule a package to run as...