Try this

if object_id('tempdb..#data', 'U') is not null

drop table #data;

create table #data

(

EQID int

,Revis int

,Filename varchar(20)

,JobCode int

,JobQual...

Do you get any error or warning messages?

komal145 (11/4/2015)

---

hi,

I have a script task that reads the variable named"result" ( the stored procedure is ran in execute sql task and stores the result in this variable) and...

hoseam (11/4/2015)

---

'2013-01-01'

withdrawal_date

resigned_date

I want to check, if the member was active during '2013-01-01 and withdrawal_date. Now withdrawal_date can be anything really, it can be '2014-01-05' or '2010-05-02'....

And I'm using resigned_date...

If you have 2012 or later. an easy way is to use TOKEN.

Assuming the file name is held in a variable called Filename (yes, I'm feeling creative today), your expression...

Sorry I can't help.

Whatever the problem is, it's fixed now. Cannot reproduce in 2014.

pharmkittie (11/3/2015)

---

I am fairly new to SSIS but not to SQL Server. Here are the conditions of the flat files:

1) there will only be one flat file...

vipin_jha123 (11/3/2015)

---

Hi All,

I am working on 1 POC project.

I have 2 customer having source file in txt format, but the column sequence of both customer are different.

Number of column in...

Manic Star (11/2/2015)

---

If your database needs to be available from more than one machine, and you don't have a server to host it, you might consider an Azure solution...

SQThaal (11/2/2015)

---

Hi,

I was asked to go through stored procedures and make modifications so SQL injections would be impossible.

I read a lot of articles on sql injections and I see...

Nice response, Jeff.

In SSIS world, I often have to correct his confident-sounding assertions too.

sqlfriends (10/30/2015)

---

We are upgrading our SQL server 2008 R2 to SQL server 2014.

We have about 10 packages in 4 solutions.

And we have been using configuration file and save packages in...

Your Dev db is on the same instance as the Prod db? If yes, that's the first best practice to apply: don't do this!

yb751 (10/29/2015)

---

Ed Wagner (10/29/2015)

---

yb751 (10/29/2015)

---

I was on my last eye twitch yesterday (so to speak) so I put together this image. (attached)

I was thinking about unleashing it but then I...

SUBSTRING(AutoScore,1,4) == "APP1" --> APP1 output

SUBSTRING(AutoScore,1,4) == "APP2" --> APP2 output

...................