Why not avoid the datatype conversions completely?

declare @Today date

declare @NowTime time

select @Today = getdate()

,@NowTime = getdate()

select @Today

...

manibad (5/6/2013)

---

sgmunson (5/6/2013)

---

I'm at the point of making an assumption about what the poster meant by their most recent post. Given the technique of concatenating a series of...

pmcquirk 96901 (5/6/2013)

---

Basically I am recieveing multiple flat files of two different file layouts, the file names do not give a clue to the layout, howevet the files (pipe delimited...

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