Questions tagged [ssis-2008]
10 questions
7
votes
1 answer
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 example, suppose I have a table called mytable with 5…
jessieloo
- 173
- 4
2
votes
1 answer
Is it ok to have huge page life expectancy?
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
- 21
- 1
2
votes
1 answer
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 the run duration has increased and I would like to…
Feivel
- 507
- 8
- 15
1
vote
1 answer
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 and SSIS 10.5 to manage these servers and develop…
ggle
- 173
- 5
0
votes
1 answer
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 :
Pass the SSIS package to Job (Looping the…
Lakshmi R
- 119
- 1
0
votes
0 answers
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 2008Server will not connect. Nothing changed on the…
mcv110
- 75
- 1
- 8
0
votes
1 answer
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)DATEPART("mm",GetDate()) ,2) + RIGHT("0" +…
pee2pee
- 194
- 1
- 3
- 9
0
votes
0 answers
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 specified
, knowing that:
1 I installed Oracle 11g express…
dex
- 1
0
votes
1 answer
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 used to check what Data Flow Tasks are required to…
Kevin
- 533
- 2
- 12
- 20
0
votes
1 answer
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 run the SSIS package it returns the following…
sss
- 1
- 1