Jeff Moden (3/13/2011)

---

If you have the data to exercise Wayne's good solution, you might want to look into what a BCP format...

jashwantsingh (3/11/2011)

---

Yeah...I will do the same...I will remove friend from front end.

I think, its not a good idea. Can you suggest something better ? How do you people deal with...

sumpritpurabi (3/11/2011)

---

Thank u sir, your query is an immense help for me. Now i can proceed further. But sir i want to ask you one more question. can u just...

sumpritpurabi (3/11/2011)

---

Sir/Madam, i am in a confuse mood. i could not able to retrieve data from database based on current date and time.

i have used GETDATE() function but still no...

DMS11X (3/11/2011)

---

I cant have the keys defined by MMDDYYYY-HHMMSS, Simply because we function 24hrs, and since we are on PST, every year in the fall the clock cycles back 1hr,...

josetur12 (3/11/2011)

---

Hi, I have a flat file with over 200 fixed length columns. I want to use SSIS to load the data into SQL Server.

Is there a way...

When the SSIS packages are stored to disk, they are stored as .dtsx files. These are XML files, so with a little bit of investigative work, you can write a...

donato1026 (3/11/2011)

---

Sorry, but I won't be able to do that. This can be used on any database...

For more complex pivoting (tracking multiple columns, dynamic), or for even a way that is normally a better performer, check out the two articles in my signature on Cross-Tabs /...

Well, running from BIDS is different from running from SSIS - I assumed that you meant the agent was getting this message.

A couple of possibilities:

1. Use 7Zip.

2. CozyRoc has a...

Aw, he's not that bad!

Welcome!:-D

Digs (3/10/2011)

---

Yes the MAX(ID) does do that, thanks.

This code does not...

SELECT t1.*,

PrevId = t2.ID,

PrevSub = t2.Sub,

...

Brandie Tarvin (3/10/2011)

---

... I run this script in SSMS and I end up with the correct value in my SELECT. But as soon as I'm running it in SSIS, I'm...

Here's another method to accomplish it, utilizing self-joins:

SELECT t1.*,

PrevId = t2.ID,

PrevSub = t2.Sub,

...