can you please explain in detail if it is just ODBC or teradata ODBC?

can i send paramter in my sql query?

I tried it worked.

i have one more scenario

How do i implement the single quotes in the attached file. any help

i tried to use cast on both. but no luck

i tried to change the datatype of two fields of both tables to int.

which actually makes both the table data...

Thanks for the information.

i can't find out before the websevice task if there is going to be any error or not.

you can do webservice task and parameter by installing sp3 (sql server 2005)

i tried thru generate xsd and got this error

Unable to infer the XSD from the XML file. The XML contains multiple namespaces. (Microsoft Visual Studio)

thanks jack

i have flat file source

data conversion

ole db destination

where should i add the script component in the flow? can you please let me know

Thanks Jack

i actually wanted from the date column the month and year

08-09-2009

i need August 2009

how do i do it in derived column?

Thanks it worked.

kishore

Were you able to find a solution for your problem. i have same scenario not able to do the parameter to web service task.

Please let me know if you have...

Thanks for the help.

i created an variable in package level with datatype as object

created an execute sql task

resultset as fullresulset , connection and the sql statement

in the resultset :...

Thanks for the help.

i created an variable in package level with datatype as object

created an execute sql task

resultset as fullresulset , connection and the sql statement

in the resultset :...

i created an execute sql task and taking the particular column i need and storing it to a package variable(user::people) with datatype as object

Then i have a for each loop...

Thanks for the documentation.

Can you please tell me if i have to do the input parameter from a table column value, how do i do it?

Thanks a lot.

i think i can't use web service task as i have pass parameter and i dont think web service accepts parameter from table.

if i have to do thru...