pshrvankumar (11/5/2015)

---

Thanks Anthony,Problem was partial solved but I have below table. Please help me with the below puzzle. My table CSAT has below columns.

TRANIDREVISION FileName JobCode...

Welcome!

Based on what you have told us, the answer is yes.

But we cannot tell you exactly how without knowing how the database is structured.

Details of guests, periods of stay and...

Ian C0ckcroft (11/5/2015)

---

Hi guys,

when opening a package i get the error:

Error 5 Error loading 02 04 XLS_GL_Load.dtsx: The connection "NHDQCOG01" is not found. This...

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...