Construct your SQL Statement in a variable of type string.

Something in the like of:

REPLACE("

select * from <DB_Source_Name,,>.myTable where colA = 'Test'

",

"<DB_Source_Name,,>", (DT_WSTR,50) @DB_Source_Name)

In this code snippet, @DB_Source_Name is a...

aharmon-1091890 (4/6/2010)

---

are you getting any errors or warnings when you execute the package? My initial guess is that SSIS is trying to guess the datatypes, and when it sees the...

You could use a script component/task to write the data to the different .csv files. You can find code snippets for doing this all over the web. The only thing...

Bru Medishetty (4/2/2010)

---

Hi thanks again for that.

I am using OLE DB Destination and I do not have table or fast load option for data access mode. The property you mentioned...

What is the value of Maximum Insert Commit Size? If it is equal to 0, SSIS will try to insert all the rows in one single transaction.

What does your SSIS package do?

Does it do a simply reading of the data residing in the SQL Server and writing it to the Oracle Server, or are there other...

kanth.vishal (3/26/2010)

---

Yes the source file is a text file and it is using Flatfile connection manager .The data type is string[DT_STR] and width input column width is 0 (read only)...

Read the 4 articles on SSAS deployment here at SQLServerCentral, starting with this one:

http://www.sqlservercentral.com/articles/Analysis+Services+(SSAS)/69467/

Quote from MS TechNet:

By default, an attribute hierarchy is created for every attribute in a dimension, and each hierarchy is available for dimensioning fact data. This hierarchy consists of an...

divyanth (3/24/2010)

---

Try using your SQL as part of expression and Use that Variable as your source in OLE DB source/ execute SQL task.. That way you will be able to...

Ah, then I'm indeed mistaken. Thanks for correcting...

Where are you trying to do this? Directly in the property field?

To use variables in your arguments, you must set the argument through an expression.

See the the third tab Expressions...

It is not the account of the user that created the job that is used to execute the job, it is the account of the SQL Server Job Agent. See...

Unfortunately, I have zero experience with 2000.

Maybe someone else?

Ah, yes, you could store the first line of the file in a seperate array and use that one to create the column titles.

It is not really using arrays in...