May 19, 2011 at 9:20 am
I have a SIS package that I had orignally created in 2005 and have had to convert it to 2008 to run a SQL 2008 box.
The package had worked without a problem using 2005 but since I need to use a ODBC data source from Progress to access a Progress database it is giving me problems now.
I've found out that 2008 does not store the password in the Data Source file so everything I've read on this says I need to use a Package Configuration.
I've went in and built the Package configuration and have it stored in a configuration table in my destination database and have it checked to user Package Configuration
When I go into a Data flow task and I do a preview of the data coming from my Progress database I can see the data.
When I go back to the Control flow tab and try to execute the Container the Data flow task fails on the part where it is pulling the data from the Progress database.
Any ideas or suggestions would be greatly appreciated
Thanks in advance.
May 19, 2011 at 11:14 am
Try using a XML file for Package configuration and store the password in it.
I believe the package is failing because it is not able to connect to the server (db), so even if we store the password the package cannot access it.
Let me know if this works.
May 26, 2011 at 10:17 am
Apoligize for taking awhile to get back to you on this.
I switched the Package to look at XML and now when I open the package it starts through it's validation of the containers and gets to one of the containers and it's been trying to validate it for an entire day and still stuck on it, and the only way I can get out is to use Task Manager to shut down VS 2008.
Any ideas/suggesstions would be appreciated.
Thanks
May 26, 2011 at 11:02 am
Hi,
Have you stored all the required information in the file?
In our project we have an OLE DB connection to SQL Server so we store the server name, user name and the password in the file.
June 7, 2011 at 6:24 am
I've been working on this SIS package still and have to completely rebuild the package 3 times now from the ground up.
In the Configuration File I have the Connection String, User Name, and password.
On this last build of the package when I run the 1st 2 Containers seperately they work fine. When I try to run the 3rd container which all run from the same data connection it errors out saying the connection is bad.
Since I have 10 different containers all accessing the same data source, in the SIS configuration file there is an option to Retain the same connection but I can't change it and can't find anywhere in the package to change the setting to use one connection and keep it open while all transactions are ran, or if that is possible.
With taking about 4 hours to rebuild this package every time, this is getting to be a pain.
Any suggesstions would help.
Thanks
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply