Questions tagged [ssis-2008]

The tag has no usage guidance.

6 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
0
votes
0answers
26 views

Changing SQL Server2000 settings after converting to VM?

We have migrated a SQL 2000 server to VM and I am wondering what changes will need to be made on the VM? After the VM migration an SSIS package that transferred data from the 2000Server to a ...
0
votes
0answers
23 views

SSIS package run error indicates wrong credentials after VM migration

First, I am not a SQL DB admin. I inherited this system and working to migrate away from it...that said: I have an old MSServer2000 SQL DB we migrated to VM. That server offloads data to another SQL ...
0
votes
0answers
20 views

Path of ssis package

Good morning all I must migrate this ssis package from SQL 2008 to SQL 2019 I'm trying to see how I can find the physical path of these packages thanks
0
votes
0answers
228 views

SSIS Package Fails when run from sql agent

I have an SSIS package that is loaded onto the a SQL Server. The package fails when executed as a sql agent job, but the package runs fine when the user goes into the ssisdb catalog. The job is ...
0
votes
0answers
92 views

Oracle source with SSIS 2008

I am trying to use an Oracle OleDb source in my SSIS package with no luck, every time I try to connect to the server I get the error: ORA-12154 tns could not resolve the connect identifier ...
0
votes
1answer
3k views

Error when running job using SSIS package

I have SQL Server 2008R2 installed on my Windows server 2008. I created a package using the Import and Export Wizard from file system. After that I created a job (SQL Agent Job ) that used the SSIS ...