which column indicate...

is there any TRY CATCH Clause you are using inside that store procedure ?

nice question for basic knowledge related to windows functions Steve

Thanks for sharing 🙂

you want to show PAD 4 = April 2008.

you need to map the PAD column data to represent your needs, as there are no dates, as you only...

It giving zero because there might be not data...

i hope you might have found the solution for this. anyways for the sake of curiosity oracle drivers are installed on the server? where you are deploying the job ?

its a cross post

you have already put same question earlier here http://www.sqlservercentral.com/Forums/Topic1511010-3077-4.aspx

it would be easier if you tell us what is the confusion and where you think these are the same:-)

okay, 1st thing 1st how did you checked that if the SSIS is installed on the Server?

2ndly, create a temporary SSIS package which dump the data from the source to...

this is a good option, though if you need to see only a specific User entry data must be inserted in a new dimension to filter out the data. you...

what about manually executing the package ?

you must have some data / value to determine if this data belongs to the user or not.

is there any column which maintain this data in your cude ?

Try to execute the package on the SQLSERVER manually. and if possible check if SSIS is installed on that Machine.

set the 32bit option in the to true for the job and run it again.

when you run it in Visual studio, What is the value you set in "Run64bitRunTime"?