pnr8uk (10/28/2013)

---

Actually it is more complicated than a REPLACE will allow. The REPLACE allows me to choose the column now, but later on in the package, I need the proper...

pnr8uk (10/28/2013)

---

Thanks I thought of that, but sadly the value is then wrong on what SQL is looking for:

The FileSystemPath has to match exactly, so if I remove the apostrophes...

How about replacing ' with '' in your fileSystemPath variable when you create the SQL?

blasto_max (10/28/2013)

---

I am not able to convert SSIS get date to sql server datetime format. I saw some error which i don't remember. anyway, so i decided to execute sql...

Thanks for the concise article Dwain - an interesting read as usual.

To assign the results of a query to an object variable, use an ExecuteSQL task, not a dataflow. Examples abound, here's one I found.

rocky_498 (10/24/2013)

---

Here is the Sample Data

ID,DISTRIBUTOR BCITY,ACCOUNT ID TYPE,ACCOUNT ID

DS,BP9744524,CARLSBAD,D,BR9307299,UNKNOWN

I can Open this .DAT file in Notepad. Client just want above format files in .DAT format.

Please guide me or...

If this was your question, why did you start the thread with:

How do I...

blasto_max (10/24/2013)

---

Koen Verbeeck (10/24/2013)

---

Just curious: why do you use a script task as a destination? What is your destination?

Maybe there are easier alternatives.

As long as you don't use any blocking...

Some rough pseudo-code:

rowA = readRow;

rowB = readRow;

do

if (rowA.Type != "Test" || rowB.Type != "Test")

ignore

else

output rowA;

rowA =...

Even better (IMO) is to use something rare as your column delimiter (eg |).

Then you don't need the extra "s & save some disk space...

This can definitely be done using a Script Component. It should be asynchronous, because not every input row will have a corresponding output row.

I did not reply sooner because your...

What have you tried?

Rather than looking at the source data in Excel, can you please open it in Notepad++ or similar and then have a close look at the offending data?

From your screen...

scuby.me (10/22/2013)

---

i have a ssis package where i need to import data from excel to sql table which does it job perfectly. and also i have execute sql task which...