OK, I see what you are getting at, thanks. I still cannot see why that causes a formatting problem when outputting though.

Learner093 (5/3/2013)

---

I have a set of record types saying TH as Header and T1a, T1b, T1c, T1d, T1e, T2a, T2b, T2c, T2d, T2e as other type of records. TH table...

sgmunson (5/6/2013)

---

The number of fields that can be included in the query's use of ISNULL and NULLIF is not limited to two. You can just keep concatenating an ISNULL...

Steve Shurts (5/6/2013)

---

Very interesting... I just had to play and it was fun. However, I can't think of any clever usage for it, yet. But give me...

Hi Wayne.

Nice article, thank you.

Can you explain what you mean by: "...you can specify what the server is change all the variables at one place simply" please - it...

SQL_Learning (5/3/2013)

---

-- but the thing is in execute process task

Execute process task 1 --- i am selecting all the .txt files and moving them

Execute process task...

SQL_Learning (5/2/2013)

---

Hi,

I was trying to get all my .txt and .csv files from one folder and move them to another folder so, how can i do...

dfulks (5/1/2013)

---

I have inherited an SSIS package that has over a dozen Execute Package Task controls in it. They are all contained in one "master" package and that package...

Can you create a connection name which does not contain any spaces and try that?

That file does not exist. Remove the wildcard characters and use the real file name.

Daniel Bowlin (4/29/2013)

---

I suggest you read these 2 links

http://consultingblogs.emc.com/jamiethomson/archive/2006/12/20/SSIS_3A00_-Using-stored-procedures-inside-an-OLE-DB-Source-component.aspx

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/e8645006-899a-40bb-b144-6d65ee0a6290/

So the real challenge is getting the data out of the stored procedure. You could build a work table and then

INSERT...

brian.geregach (4/16/2013)

---

First off, my appologies, I am a newbie to programming and SQL.

Setup:

I have an SSIS package that inserts rows to a database. On...

I do not think that the wildcard character * is valid in file names - assuming that that is your question?

Use an Execute Process command at the end of your package to run a DOS copy/append:

copy file1.txt+file2.txt+File3.txt+File4.txt AllFiles.txt

If you can find any way that you can re-engineer this process so that you do not do any sorting or grouping within SSIS and instead use the SQL Server...