Questions tagged [ssis-2008]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
25 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
22 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
1answer
60 views

SSIS 2008: Illegal characters in path when trying to rename a file

I have a task that should rename a file I have a variable called RenameFileName \\servername\csv\BACKUP\" + (DT_WSTR,4)DATEPART("yyyy",GetDate()) + RIGHT("0" + (DT_WSTR,2)...
0
votes
0answers
19 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
180 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
84 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 ...
1
vote
1answer
94 views

SSMS 10.5 alongside 17.7

To set the scene, I maintain 4 local SQL Server 2008 R2 instances. At some point in the near future, 3 of these will be upgraded to SQL Server 2017 and migrated to azure. I am currently using SSMS ...
0
votes
1answer
3k views

SSIS - Disable Task Based on Variable Value

I have an SSIS package that runs a number of Data Flow Tasks all at the same time. Each Data Flow Task is placed inside a Sequence Container. Before the Data Flow Tasks are run, a Script Task is ...
0
votes
1answer
515 views

Error occur during Oracle and Sql Server Integration

I have developed a SQL Server Integration Services package pulling data from Oracle 11g and storing in a SQL Server 2008 database. Everything works as expected, but when I schedule a sqlserver job to ...
2
votes
1answer
119 views

Is it ok to have huge page life expectancy? [duplicate]

Recently I have buffer issue for my SSIS package. When i started to monitor metrics in perfmon i noticed the PLE is nearly 500000. Is it ok to have this huge PLE.
0
votes
1answer
2k 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 ...
2
votes
1answer
3k views

SQL job using SSIS package takes a long time to run especially in the evenings

I have a SQL job that runs an SSIS package and it basically pulls records from staging table and dumps it into the master table. It used to take around 8 hrs. to run but in these last 10 days or so ...
7
votes
1answer
1k views

SSIS OLE DB Source Editor Data Access Mode: “SQL command” vs “Table or view”

In BIDS, I'm running a Data Flow Task & I'm wondering what the difference is behind the scenes between using "Table or view" vs "SQL Command" for the Data Access Mode for an OLE DB Source. For ...