Find a business sponsor (C-level or high-level manager, if possible) who you can sell your idea to. Explain the advantages and benefits to be gained from your DW. ...

If you save the flat file connection after marking the first few (or 20) fields, it will just assume that the last field is really long. You can then...

You've got to open your .dtsx package in BIDS to do the modifications. It sounds like you're not familiar with SSIS. Take a look at Andy Leonard's intro...

winseelan (10/4/2011)

---

hi there,

i have two tables

MASTER AND CHILD

MASTER has the following columns master_id, master_name

CHILD has the following columns child_id, master_id and child_name

so, child table is referring master table master_id...

Is it a network connectivity issue? It seems I've gotten that vague (non-helpful) error message when...

Is this a case where your inline SQL is exceeding 4,000 chars in an expression so a WHERE clause is getting truncated/cut off? That may be an explanation.

HTH,

Rob

No one here is your boss. Take a look at:

http://www.jasonstrate.com/2011/01/31-days-of-ssis-pivot-transformation-1031/

duggal.priyanka06 (9/24/2011)

---

I want to check if expressions in a derived column run on a sequential manner or in parallel.I have a variable new_cost.I want to check if the new_cost calculated...

ssismaddy (9/22/2011)

---

Hi, I m trying to create a flat file with a header in it. Everything looks good, but column names and the header are coming in the same row....

Do you have a field in common (an id) between the two sheets so that you can do a Merge Join as opposed to a Merge?

We're not mind readers here. With no information, how would you expect anyone to help you? Did you get an error? How is it not working?

Doc Brian (9/20/2011)

---

For my database architecture work, I use an old version of ER/Studio -- v5.1 running under a VirtualBox implementation of Windows 2000 Pro on Windows 7 Ultimate 64-bit...

Duplicate post

Investigate the Pivot task

asranantha (9/19/2011)

sources data comes like id,name

...

If you have an incremental identity column in your data, you could calculate the median. Then use the conditional split transformation. If the Id column is less than...