I'm an intern working in the IT department for a local company. One of the projects they have me working on is to export all their data from the Unidata system and insert it into a new SQL server (either Microsoft SQL, Oracle, or worst case MSAccess). I've been trying to use SSIS in order to export from Unidata to bring it to a SQL server I have set up locally on my own machine. I have had marginal success. Almost everytime I try, I get a different error message about one thing or another. I'm really hoping somebody has personal experience with this sort of thing, or at least can point me to a step-by-step tutorial. Please help, I've been working on this for the past 4 days, I'm at the ends of my ropes. My superiors say they gave me this task to learn, but I'm starting to think it's hazing. If this isn't the right forum, then just tell me which one could help more and I'll move it there. <EDIT> Right now, the error in SSIS i'm dealing with is this: Cannot get string literals from the database connection "Provider=IBM.UniOLEDB.1;Password=;Persist Security Info=True;User ID=myacct;Data Source=dev1;Location=mydatabase". Additional information: Object reference not set to an instance of an object. (DTSWizard) However, when I test my connection, it says it was successful. I have a similar issue in MSAccess, where it can connect to the database and find the schema information (gather table and column names) but when I try to access the information it says "ODBC -- Bad Call" and doesn't even give me a specific error code. Just so you're aware with how experienced with all this I am, I've only done my freshman year of college, but I've been teaching myself technology concepts (primarily Microsoft tech, some Unix tech) since freshman year highschool.

Let 's see the error messages in full to start off RoboGen. Also please share your package design. As an aside, in any forum you better be very specific to get replies to the point.Arthur My Blog

Ah, yes, that would be helpful, wouldn't it? Sorry about that. Right now, the error in SSIS i'm dealing with is this: Cannot get string literals from the database connection "Provider=IBM.UniOLEDB.1;Password=;Persist Security Info=True;User ID=myacct;Data Source=dev1;Location=mydatabase". Additional information: Object reference not set to an instance of an object. (DTSWizard) However, when I test my connection, it says it was successful. I have a similar issue in MSAccess, where it can connect to the database and find the schema information (gather table and column names) but when I try to access the information it says "ODBC -- Bad Call" and doesn't even give me a specific error code. What specifically do you mean with package design? Again, sorry about not posting specific error messages.