hramineni (10/9/2009)

---

Hi Ivan,

thankyou for your response. I thought that will be one option but was wondering if there is anything in SSIS that I can create a lookup component and...

gangadhara.ms (10/9/2009)

---

Thank you very much its now working correctly..

One more thing if i execute the query in Query analyzer its returning the data.But After executing the package no rows...

Go to the data reader source component and set ValidateExternalMetadata property to false. Try again to execute your package.

gangadhara.ms (10/9/2009)

---

Hi Thanks for reply as i am very new to SSIS can u pls help me.

I am getting below syntax error when i parsed the expression

I am using this...

gangadhara.ms (10/9/2009)

---

Hi,

Thanks for your immidiate reply.

Here i am thinking to store that value that is date in XML file which i need to modify out side the development environment(in every...

hramineni (10/7/2009)

---

I am new to SQL Server but have plenty of expereince in ETL .

I just started using SSIS of sql server 2008.

My requirement demands a lookup on table to...

hramineni (10/6/2009)

---

I am new to SQL Server but have plenty of expereince in ETL .

I just started using SSIS of sql server 2008.

My requirement demands a lookup on table to...

gangadhara.ms (10/9/2009)

---

Dear All,

I am new to SSIS,i do need to change the Data reader SQLCommand property.

Here I am doing simple select statement with where condition from the table in data...

phina_el (10/8/2009)

---

Yes, I can modify the file, I also have to apply to the File system task with a Operation "COPY"

to another folder (i.g Folder_Temp)

I'm still confused, how to create...

shjaffer (10/7/2009)

---

Hello -

This has just started happening - I have an SSIS job that has 3 steps on the Control Flow. An Execute SQL Task, a Data Flow and...

phina_el (10/8/2009)

---

Thank you CozyRoc. Really this is a Great help.

how about this case:

the results of last month's data, appeared at the beginning of the month .

eg this month: this...

phina_el (10/6/2009)

---

I have TXT file as source for SSIS package every month the filename is YYMM[FileName].txt.

ex0907MID.txt, 0908MID.txt, 0909MID.txt, etc.

I need to run the same SSIS package to execute the different...

greengiant (10/6/2009)

---

I have a SSIS package that has 20 data flow tasks.

Each imports a table to another. Can I do with

by providing a source table and a...

neilnewton001 (10/6/2009)

---

I've tried just putting in the ip address right into the property of the send mail task without a port; in fact that was the first thing I tried...

In the Send Mail Task you have to specify SMTP connection. You cannot directly type in IP/port. Have you tried specifying only IP address without port? Also in your SSRS...