All Questions
Tagged with sql-server-2005 ssis
400
questions
0
votes
0
answers
39
views
Possible reasons for an SSIS conditional split into the same destination table?
I've been given the unenviable task documenting the catalogue ingest process of our data warehouse. All was going well until the end where I came across the use of a conditional split inside of an ...
1
vote
0
answers
509
views
ssis ftp task error The operation timed out
I am using sql server 2005. The sql agent calls a scheduled job which includes 4 steps. Each step calls an ssis package and each package includes a single ftp task. Each ftp task, downloads a file. ...
- 740
1
vote
2
answers
2k
views
SSIS solution - Developed with 32-bit ODBC driver. Need to make some tweaks to the solution to run with 64-bit ODBC driver
At the moment we have a solution running fine under the 32 bit ODBC driver in DEV environment and this 32 bit ODBC driver doesn't exists in PROD. There is a 64 bit ODBC driver in PROD though. I did ...
- 305
2
votes
1
answer
69
views
How install Integration Services in sql-2005
I need to install the SQL component Integration Services is to create ETL but the component is disabled, How can I install it?
- 25
1
vote
2
answers
54
views
Get date format as Test_170727_1608.txt.gpg
I am trying to send attach a file thats been created and send as an email using "exec master..sp_sendSAM" in an SSIS 2005 flow.
This is what I tried
'Test_'+ convert(varchar(12), getdate(), 12)+'....
- 133
2
votes
1
answer
130
views
Executing SSIS package on SQL server 2005
I am working on upgrading legacy applications that used DTS packages. This is the first time working with SSIS packages.
The application (which lives in various places) will need to invoke and ...
- 87
1
vote
0
answers
618
views
Metadata could not be determined in SSIS OLEDB source
I am trying to use dynamic query inside OLEDB source, but getting
"Metadata could not be determined" error which is usual.
I used WITH RESULT SET (in SQL Server 2012) inside the Stored procedure ...
- 145
0
votes
1
answer
57
views
Retrieve data from SQL Server 2005 with SQL Server 2008 SSIS Data Flow via procedure with parameter in data source
I was trying to retrieve data from a procedure on SQL Server 2005 and populate a table on SQL Server 2008. Packet is on SQL Server 2008. I have a SQL Task which I use to get the date. The result set ...
- 61
0
votes
1
answer
170
views
SSIS package fails with only OnPreValidate in logs when run from a .NET app
I've created a SSIS package which runs smoothly when launched from SQL Server Data Tools (I use SSDT 2015 with SQL Server 2005 Developer Edition on my PC), but fails with only the following line in ...
- 1,082
1
vote
2
answers
2k
views
Get previous day in an Expression
Just need help on this as I am new at SSIS. I got an expression but I want yesterday, not today.
"Daily "+ (RIGHT("0" + (DT_STR,4,1252) DatePart("yyyy",getdate()),4))+(RIGHT("0" + (DT_STR,4,1252) ...
- 133
0
votes
1
answer
103
views
How to name a CSV file with yesterday's date?
I need a SQL job to run every day.
This CSV file needs to be named with yesterday’s date. So, if this job was to run today, it would generate a file called 20160820_invoices.csv.
I use following ...
0
votes
0
answers
747
views
sql server agent job fails while execute
I'm trying to execute ssis package in sql server agent job . while start the job am facing the sql job fail. below i attached the screenshot of the error.
NOTE : it is running fine , if i execute ssis ...
- 63
0
votes
1
answer
1k
views
how to assign the variable to the argument in execute process task?
i tried to pass the variable in argument (execute process task) .
i read msdn article in that they told to pass like @variablename in argument.
i tried @variablename,@[User::variablename] but couldn'...
- 63
0
votes
2
answers
598
views
pass a column value to ssis variable
I have a job that I want to run that passes a variable to an ssis package. The variable is a filename but the filename changes daily. I have an access front end that the user enters the filename into. ...
- 113
0
votes
1
answer
95
views
Package doesnt run when moved to production
I am not sure this should be in this category or not but here is my issue.
I have an SSIS package that I am trying to move to our production server. It works fine on the QA server but now that I have ...
- 113