Bahrahsimo
Programmer
- Aug 24, 2010
- 1
Hi there
I've got an interesting issue when running a SSIS package.
I'm making used of an "Execute SQL Task" to retrieve a list, which will be used to build SQL scripts in a "Foreach Loop Container"
When running the SSIS package through the BIDS it works 100%. Also if it's run locally as a job on the database server, it words 100%.
The problem comes in when the job is scheduled.
No records are returned when the SQL Task is executed.
Any Ideas?
Background on the SQL Task:
Cnnection Type is OLE DB (Also tried ADO.Net)
The SQL query is very simple:
"SELECT distinct FileRef
FROM [CCReleasedFiles]
where [ReleaseDate] = convert(nchar,getdate(),112)"
Result Set is Full Result Set
Result Name: 0
Result Variable: User:
RecList (which is an object)
Hope someone will be able to help me with this one.
I've got an interesting issue when running a SSIS package.
I'm making used of an "Execute SQL Task" to retrieve a list, which will be used to build SQL scripts in a "Foreach Loop Container"
When running the SSIS package through the BIDS it works 100%. Also if it's run locally as a job on the database server, it words 100%.
The problem comes in when the job is scheduled.
No records are returned when the SQL Task is executed.
Any Ideas?
Background on the SQL Task:
Cnnection Type is OLE DB (Also tried ADO.Net)
The SQL query is very simple:
"SELECT distinct FileRef
FROM [CCReleasedFiles]
where [ReleaseDate] = convert(nchar,getdate(),112)"
Result Set is Full Result Set
Result Name: 0
Result Variable: User:
RecList (which is an object)Hope someone will be able to help me with this one.