Does your Flat File Connector have that column properly set as string?

Can you show us an example of File to Table conversion? (I can't see 4000 only showing up as...

Clark,

There are a lot of us that don't open attachments. Could you post your code in your reply, along with a CREATE TABLE statement (DDL) and an INSERT statement containing...

This type of code has already been posted on many sites using various methods, even this one. Try the search feature on this site and a search engine. If you...

Sumit,

Please script out your table as a DDL (CREATE TABLE) statement and give us sample data in the form of an INSERT script so we can help you out.

I assume...

Is this a homework assignment?

I don't know any of the new books, but I do recommend studying recovery / backup, learning all variations on the SELECT statement, and security.

rmechaber (7/10/2012)

---

Brandie, here's a link I found that suggests it is possible to fail a job step with RAISERROR:

http://www.bidn.com/blogs/Daniel/ssas/2313/force-a-sql-agent-job-step-to-fail

I just tested this by creating a dummy Agent job with 2...

I've never heard of disabled indexes causing any problems.

Are your execs logging into Integration Services and executing the package from the Stored Packages folder? Or are they running them from the child jobs?

So far as I know, it's not possible to pass an error outside of a jobstep to cause the job itself to fail. The error is only relevant inside the...

Thank you for letting us know. That will help with future questions.

Glad you got it working.

Heatstroke

Tell me about it!

Sure enough, same issue on the other packages that are having the exact...

Oh, for the love of ...!#(*%$#W$

I think I just found out what the issue is. EDIT: Forget the screenshots.

I have a file that comes over from a vendor named MyFile...

GilaMonster (7/6/2012)

---

While I belive you can insert into the job history tables (they're not system tables), it would probably be better if you created your own history tables for the...