Skip to main content

Questions tagged [ssis-2008]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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 ...
jessieloo's user avatar
  • 173
2 votes
1 answer
163 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.
das's user avatar
  • 21
2 votes
1 answer
4k 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 ...
Feivel's user avatar
  • 507
1 vote
1 answer
111 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 ...
ggle's user avatar
  • 173
0 votes
1 answer
763 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)...
pee2pee's user avatar
  • 194
0 votes
1 answer
5k 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 ...
Kevin's user avatar
  • 533
0 votes
1 answer
326 views

Run SSIS Package but the package path will be decided runtime

I have to import 16 Excel files into 16 tables through agent. The agent will process the data further. I have created a SSIS package for each . I don't want to create 16 jobs to do same steps. My idea ...
Lakshmi R's user avatar
  • 119
0 votes
0 answers
36 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 ...
mcv110's user avatar
  • 75
0 votes
0 answers
171 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 ...
dex's user avatar
  • 1
0 votes
1 answer
806 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 ...
sss's user avatar
  • 1
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 ...
Eyla's user avatar
  • 219