Here's an example. I changed the code provided by Ed, not because of it being wrong, but because I don't like columns named simply ID and don't like identities on...

This article might help you:

https://www.virtualobjectives.com.au/sqlserver/dts_sql2005.htm

I hope that you already have the DTS Designer Components installed.

It's more an optic illusion, as those...

It's possible, to do this using dynamic sql.

The main problem is to know which are the possible values for INVENNO and what column name will they represent. If you can...

For indexing, you could use something like this:

CREATE NONCLUSTERED INDEX IX_Orders_Cover1

ON dbo.Orders(Type, Status)

INCLUDE (Value, Discount)

The Type and...

Using a 2008 Evaluation version would give you 90 days to complete the migration without having to pay a license.

Have you tried the import/export wizard to create an SSIS package and use that on your SQL job?

That's probably the best way to write it, I'd just add and additional condition for Type IN(3, 4).

Why do you want to change it?

This procedure can be changed into set-based code. I just don't want to risk posting an incorrect solution and getting blamed for that as I don't have any sample data...

sgmunson (7/10/2015)

---

Luis Cazares (4/22/2015)

---

This can be done with a recursive CTE. You can find many examples on the internet.

It should be something like this:

WITH RCTE AS(

select T1.a1, T1.a2, T1.a3,

...

I can't remember if this is the exact syntax, but it should be something like this:

TRIM( ENT_DATE] )=="" ? (DT_DATE)NULL(DT_DATE) : (DT_DATE)(SUBSTRING(ENT_DATE],1,4) + "-" + SUBSTRING(ENT_DATE],5,2) + "-" +...

This stored procedure is full of problems. The RBAR (Row By Agonizing Row) is extreme and I'm having some problems figuring out what you're trying to do.

You need to find...

Have you checked that your connection settings are the same in both SSMS and SSRS?

Have you used something to check where's the problem such as profiler or extended events?

p.shabbir (7/9/2015)

---

You can also define that column as a date in the connection properties for the file and get the error in there.

Either way, you're reading the whole file and...

That's exactly what it will do to prevent sending blanks when you intend sending nulls. You can change that if you're certain that you'll only receive nulls to compare as...