Here's the situation. I am converting DTS pkg's to SSIS (2008). When I copy this SQL from DTS (which executes just fine in DTS) and paste it into...

perrrrrrfect !!

Thx Ian !!

I have the same warning appear on all my SSIS package executions as well. I am running the packages as local administrator w/ sysadmin on the SQL Server....

I was told by our Sybase DBA that Sybase Clinet 15.3 does not use sql.ini anymore...

Sorry -- still don't understand.. as a DBA, I've coded a proc which is successfully invoked by our developer's front end VB 6.0 GUI... (ADO)

My developer is requesting a...

cool suggestion.. cool beans.. thank you!

Elliott - thx for the quick reply... question -- our "system drive" varies from Dev, to QA, to Prod (in Dev it's C: -- In QA & Prod it's D:...

thank you !

thx.. yep, all I had to do was enclose the underscore in double quotes... and double up the \\ within double quotes.. worked great !!

Elliott - thx. (great minds think alike) it worked...

prior to your feedback, I actually did default the newly created variable 'values' to actual valid values (Dir name, File name,...

yep.. proactively determined & corrected that.. I now have NO paramater mappings. I setup my Result Set to include the Variable Names...

Still -- I receive the Connection Manager...

thx Elliott -- still having an issue & hoping you can help me out:

I used your suggestion to create a couple of pkg variables, populate them indidually via EXEC SQL...

Actually, I am well versed in the use of Package Configurations using a .dtsConfig file housing variables which match my Package variables.

I typically pass hardcoded values (Connections, Provider strings, Directory...

To enable Auto Hide for tool windows:

http://msdn.microsoft.com/en-us/library/z4y0hsax(VS.80).aspx

1.On the Tools menu, click Options.

2.Expand the Environment folder, and then select General.

-- The General, Environment, Options Dialog Box opens.

3.Under...

This link was somewhat helpful:

http://www.nigelrivett.net/DTS/SSISConfigurationFile.html

Essentially, you manually setupo your connecion to your Oracle Server & DB.. then generte the XML file using SSIS Designer tools:

- Load the package...