If you see i have duplicate records in All FIELD and also most seriously Duplicate records between two or more columns....

DISTINCT is not working in my case,here is my code...

What sort of macro?

Koen Verbeeck (5/16/2012)

---

Indeed a strange problem.

Uncached lookups are of course very slow, but I don't really see a reason why the package should hang.

Did you try a cache connection?

How is...

khorkh888 (5/15/2012)

---

Hey All Expertises,

I am facing problem to load a batch of text in Excel into sql table using SSIS. Here is in Excel look like:

Date KPI...

You didn't mention the 'c' word...

Really? Did not know that - thanks for sharing.

Not that I know of.

But there are a couple of things you can do.

1) Find a decent text viewer that will open big files quickly and allow you to navigate...

vinu512 (5/14/2012)

---

tbabs25 (5/14/2012)

---

Can anyone help me in coverting the output I am geting when a type in my select statement.

I get a number in return instead of data.

select va_title

from contact...

SSIS sorts are heavy on RAM - have you checked the server's health at the point where the sort goes bad?

If you want to be a bit more sophisticated, one thing you could do would be to set up an import-logging table along the lines of:

BatchNo

FileName

RecordsInFile

RecordsImported

RecordsUpdated

Your package would need to...

Shouldn't be hard - post back if you can't make it work.

The column could be stored as a datetime and another computed column added which does the suggested CONVERT on the date to store it in the format you require. Seems...

Looks like 62 points to me 😛

haichells (5/8/2012)

---

bcp may not work because the output of a stored procedure needs to be exported to a flat file. since it is not taken direct from a table nor...

+1

Please provide some sample data, along with expected results, which may make...