I would explain to the customer that if I can't create a db field to store this info, that hard-coding is a terrible solution. Not knowing how/whether the list...

Substring cannot take negative values for the length argument.

erics44 (7/31/2012)

---

I am relatively new to ssis although i am getting better 🙂

I seem to struggle with lookups tho, a lot of the time i get the "lookup doesnt yeild...

If I am understanding correctly, the field you are bringing into the flow via Lookup is null where there is no match (as it should be) but you wish for...

Subbu's (7/27/2012)

---

I am getting error while executing an SSIS package through batch script.

My package is having 12 Execute SQL tasks(EST). I am getting this error from the first EST.

In this...

Smash125 (7/27/2012)

---

This may seem very simple for many of seasoned SSIS punters. I wanted now for extracting data from OLEDB source we use different options like

- Table Or View

- Table...

richykong (7/19/2012)

---

I've always tried to build views in SQL for a filtered data set instead of using the named queries. In my opinion, views are easier to manage and...

Mine have logging in them from the very start so I can track every time a package has been fired from dev or prod, agent or not, as a child...

change the time of the job run to see if the problem goes away. Could be you are bumping up against a process already running and your process times...

In your first example, if you remove the conversion to boolean, it should work. The problem is that you are attempting to insert a data type (boolean) into a...

There is always a reason. What is the error message?

I usually see something like "violated integrity constraints" as we do not allow nulls and sometimes one attempts...

Tripz (7/16/2012)

---

Hi,

I went to the command prompt and tried executing the command from batch file.

Please check the below command and msg that I am getting

C:\>dtexec pscp.exe -q -pw xxxxx...

Well, not enuf in the error message for me to take a shot, so I'd recommend taking the CommandLine text from the job step and running from command prompt.

type dtexec...

We do incremental, SCD1, we simply don't insert, we replace existing dimension table with the newly staged table. Partition switches occur very fast, inserts may or may not...

If you open your DSV in BIDS, right-click on the design surface and select...