Questions tagged [ssis-2008]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
30 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 ...
user avatar
  • 75
0 votes
1 answer
227 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)...
user avatar
  • 194
0 votes
0 answers
277 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 ...
user avatar
  • 656
0 votes
0 answers
112 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 ...
user avatar
  • 1
1 vote
1 answer
105 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 ...
user avatar
  • 173
0 votes
1 answer
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 ...
user avatar
  • 493
0 votes
1 answer
591 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 ...
user avatar
  • 1
2 votes
1 answer
133 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.
user avatar
  • 21
0 votes
1 answer
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 ...
user avatar
  • 189
2 votes
1 answer
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 ...
user avatar
  • 507
7 votes
1 answer
2k 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 ...
user avatar
  • 173