Hi,

Could you elaborate more on what you mean by that there is no correspondence between Oracle and SQL Server tables and fields?

Regards

Hi,

Indeed SSIS would be a very good tool for the purpose, especially when you have a large amount of data to transfer. BCP and Bulk Insert are only used if...

Hi,

But you could do this:

First transfer data to TableX using a Data Flow task. Then you could Have another Data flow task where you would have data coming from...

Hi,

Another thing that I would like to add is that this is not a server-side error. It's an error caused on the client side when the client tries to load...

Hi Aranga,

I'm not an Postgre guy but this error comes up due to the entire set of records trying to get loaded onto memory. try considering breaking up the transfer...

Hi Utsab,

Wouldn't you like to first transfer data to TableX and then transfer data to TableY?

Gogula

Hi Robert,

If you're looking at the Variables window, it would obviously not show the value '2', that is because the value '2' was assigned only during run time. This is...

Hi,

You could use the system variable "System::InteractiveMode", this is set to "True" if the package is running in interactive mode (i.e. in the SSIS designer) and is set to "False"...

Hi Manish,

There's a sample that I could send you if you could send me a private message with your email on it...

Gogula.

Hi Manish,

Yes this can be done using DTS. You would only need two Connections objects to the SQL Server (one as the Source and the other as the Destination) and...

Hi,

Just to clarify your question; you need to get the filename from the [filename] column, then read the contents of that file and store it in the same row under...

Hi,

Well, you could do this without using an Array Variable, because the ForEach Loop container gives you an enumerator for traversing through files.

You could try this out:

01. Create a 'Flat...

Hi Brandie,

I assume that you are using an Excel Connection Manager. In the properties window of the 'Excel Connection Manager'. Find the ConnectionString property and edit by adding 'IMEX=1' to...

Hi Mike,

I simulated your problem, but it works fine for me... Even with filenames with spaces in them...

Gogula

Hi,

Thanks for the replies and pardon me for not being more specific, I was looking at something like this:

CREATE VIEW V1

AS

BEGIN

SELECT Col1, Col2, ColX FROM Table A

...