I'm with Matt on this one, SQL is not the place to do this.. Convert them back and re-import them..

CEWII

gurukiran.bhat (9/17/2009)

---

Hi All,

We are Creating a SSIS package for data transfer between two MS SQl server databases, At one point we need to use Lookup transformation, But...

I can see all kinds of issues with this methodology..

1. Memory will likely be an issue.

2. Uncontrolled number of packages.

3. No way to know if the package was successful..

And I...

SQL 6.5 could do something but not really what you are asking for..

I have to ask a different question.

SQL isn't really meant to read email and interpret it.. ...

That has been my experience as well.. I just tested it.. It resets to the seed..

CEWII

You could so it with linked servers, but I have to ask what the issue with SSIS is, that is by far the best method..

CEWII

I am about 100% sure that you can't go backward.. Sorry man..

CEWII

Jeff Moden (9/22/2009)

---

Lowell's idea is good in that it leads to a more normalized database... which I absolutely agree with. To wit, the UserName column should be removed from...

I don't see...

Right path I think..

1. One SSIS package

2. 1 or more Dataflow components, it can be either, one is probably the easiest, no need for sequence containers.

3. Create start and end...

In the progress tab when the package is running are you seeing Validation Complete and other messages, this tab should give you more informatio about what it is doing..

CEWII

Could there be a transaction that is getting rolled back?

CEWII

Are they three queries that generate different structures and you want all three in one resultset? Or three seperate queries to go in three seperate resultsets.. If it...

I guess it means anything other than 0 is true.. I tried -1 and got true as well.

CEWII

Check the other thread.. I already answered it over there..

http://www.sqlservercentral.com/Forums/Topic792280-392-1.aspx

CEWII