kiran.rajenimbalkar (2/2/2012)

---

Hi,

I have to insert data from excel sheet to sql server table.

so can you please provide me the solution for how to do this in details.

I am using sql...

Very interesting. Thanks for the links!

Lookup Transformation

Google for SSIS lookup tutorial and you'll get lots of interesting links.

Ah OK.

I don't think it is possible to read and write from the same file at the same time. It would probably give interesting concurrency issues.

So first read the flat...

rohit3556 (2/2/2012)

---

my flat file contains a column name as Insurer-Dimension-key which is foreign key to the table insurer_Dim

now i am doing look up using this Insurer_Dim

in final destination, ...

And did you configure the TNS names.

There should be a TNSNAMES.ORA file somewhere in your Oracle folder that contains all...

SSIS selects the data from Oracle. As Oracle returns the data (which isn't everything at once for such a big dataset), SSIS starts to fill up the buffer. Once a...

What do you mean exactly with that?

Can you...

Now you make me curious. Which issues are you referring to?...

Maybe there are some network issues at the time that job is scheduled? (or other I/O issues)

No, you can't.

You can reference the alias in an outer query, or in an ORDER BY, but not in another expression in the same SELECT clause.

Great question. I was looking for a trap, but apparently there wasn't any 😀

I wouldn't really call documented behaviour a twist, but maybe it is good to remind people once in a while that there are such caveat's, especially when working with NULL...

Sri8143 (2/1/2012)

---

Thanks Guys transfer sql server seems working for me...

What can i do to tune the package as i have more than 1000 tables and huge data want to tune...

Discusman (2/1/2012)

---

I couldn't complete the installation of SQL Server 2008 because Windows Powershell needs to be installed.

I downloaded powershell for XP and windows doesn't know how to run the file.

Please...