I'm also interested to see if this can be done as I've been tasked to do something similar. The only two solutions I could come up with were to...

The app is using a commandtype of SP. SSRS is also using a commandtype of SP. I was sending the exact parameters as I using on SSMS....

I'll take a look at the link provided. But what still has me stumped is when I ran a trace, the SP call is identical when compared the query...

You'll need to cast it as a varchar and not a datetime.

select CONVERT(varchar(10),CAST( (CAST(DAY(getdate()) AS VARCHAR) + '-' + CAST(MONTH(getdate()) AS VARCHAR) + '-' + CAST(YEAR(getdate()) AS VARCHAR)) AS varchar),102)

Make sure that the datatype you are inserting into is of datetime and not varchar.

Are you using a DM to look at the blocking? I wrote a similar query a few weeks back and noticed that it would return the create proc instead...

I've received that error in the past, but it's always been in the context of backing up a DB. In our case, it was a processor that was being...

Great article. I was just about to send a very similar article for submission. Guess you beat me to it:)

I see. My personal opinion is to load the data is its raw format on the DB and using SQL to do any transformations. I would suggest that...

It help out greatly if you gave us your process and what you're trying to accomplish. Can you also tell us what tool you are using to transform the...

Take out the quotes in your column name. If there is a space between Invoice and Date use brackets. Try this:

select dateadd(day, cast(right([Invoice Date],3) as integer)-1,'01/01/' + cast(left([Invoice...

Check to see that you are grabbing the full path on the for each group and not the file name only.

Ah... I see. I was assuming that there were files involved. I've never worked on an AS400, but I'm interested on how you solve this problem as...

This should work.

select dateadd(day, cast(right(100083,3) as integer)-1,'01/01/' + cast(left(100083,3)+1900 as varchar(4)))

Is SSIS a requirement? If not, why not use bulk insert to load the data. For our environment, we have a table that has the file name to...