Steve Hindle-535638 (10/5/2010)

---

One more question on this...

As I split the records up from the original file, the detail records need to have some information from their header records appended to...

Derrick Smith (10/5/2010)

---

Shouldn't it be something like

INSERT INTO INVOICES

VALUES (xx,xx,xx,xx)

There is no Values or Select in your statement...I've never tried without it but I would imagine that would throw an...

lk-681111 (10/5/2010)

---

That's what I thought. I just need a way to get around that; this email has the potential to have to go out to over 100 people, so 256...

Grant Fritchey (10/5/2010)

---

Steve Jones - SSC Editor (10/5/2010)

---

I see this a lot, even with authors. People think you are following along with them, or they don't realize they're skipping...

tmurray 69699 (10/5/2010)

---

if you look at the set up of mycommand in the first part of my post I have ending paren after conn2.

When I go into immediate window and...

It's not in the text...

There's a 256 character limit on the email address fields.

http://technet.microsoft.com/en-us/library/ms142165(SQL.90).aspx

Where's your closing parentheses that should be near the last '0'?

The first thing I would check is if the string is being cut as it comes out of the database table. Is it possible you're using a SQL variable...

Is it time to implement some sort of entrance exam for SSC? After reading the question I actually spent a few minutes staring at the screen thinking "What .......?...

pwalter83 (10/5/2010)

---

Hello Friends,

I want to run the 64 bit SSIS package from the SQL job agent. I understand I need to select 'Operating System (CmdExec)' as the Job 'Type'. ...

wcwarner (9/16/2010)

---

Hello,

I have a very simple pkg that truncates a table and pumps fresh data into the table nightly. I have been able to capture the errors in an event...

The issue here might fall under the classification of undocumented feature, if you know what I mean.

Brandie Tarvin (10/5/2010)

---

... I confirmed this issue with Brian Knight, BTW. He says that Expressions in the File System Task don't work the way I wanted them to work and...

Paul White NZ (10/4/2010)

---

jcrawf02 (10/4/2010)

---

You should...