Use a script task in your control flow to get that information from the file name and store it in a variable. You can then use that variable in...

I would have to see the file format before even thinking about options.

Instead of removing the identity specs, take a look at: SET IDENTITY_INSERT tablename OFF

Are the other select statements doing anything other than just returning values? If not then I can't see why they are needed.

I'm having trouble picturing why statements that are returning...

Luis Cazares (5/27/2014)

---

This is just an idea that might work and a shot in the dark at most. Maybe a nested replace will perform better.

Something like this:

DECLARE @CSV ...

ChrisM@Work (5/28/2014)

---

Alvin Ramard (5/28/2014)

---

Luis Cazares (5/27/2014)

---

Alvin,

The code makes clear that there's a concatenation based on multiple values on a single column.

CASE WHEN A.[COL_1] LIKE '%cricket%' THEN 'ck' + ','...

Luis Cazares (5/27/2014)

---

Alvin,

The code makes clear that there's a concatenation based on multiple values on a single column.

CASE WHEN A.[COL_1] LIKE '%cricket%' THEN 'ck' + ',' ELSE '' END...

Excuse me Luis, but where did you get the idea that a redesign...

Brad,

You do not have to recreate anything. You can edit each data flow, including the associated connections, to add the required column.

Steve Jones - SSC Editor (5/19/2014)

---

David Burrows (5/19/2014)

---

As in...

The above version seems to work.

The last script posted shows the Primary_Key_Ind = Yes for every column in my database.

That's definitely not correct!

You're welcome and Happy New Year to you too.

Let us know if you have any more issues.

Your problem is that you have not restricted the times as you wanted to.

You're asking for values between 12/15/2013 17:00:00 and 12/21/2013 08:00:00 not between 12/15/2013 and 12/21/2013 only where...

It would be helpful if you told us what issues you're experiencing.