i use this program to transfer dts packages

http://www.sqldts.com/default.aspx?272

forgot it. bad data in data file. sorry

</cm>

Thanks for the quick reply. I also go this to work

Cast(CSI.CSICode as char(10)) + ' ' + CSI.CSIName

FOrget it. I was caught a stupid mistake on my end. Thanks again.

Thanks for the replies. COALESCE('%' + @FirstName + '%',Contacts.FirstName) I am simply trying to add a a wildcard filter on to the parameter but it does not seem to work...

I usually do strip out with script, but this is for multiple dts jobs that generate txt files. we have html in the description so i guess i could just...

Thanks for all the replies. However the data is coming from an extract and parsing the data into 2 columns is not feasible. Is there a standard function for...

thanks for the great reply.

I feel like an idoit. Someone else created this table and i never thought to look at the data types. no wonder the query wasnt working. sorry to bother. thanks

works beautifully. thanks for the always quick responses. this is the best community.

i realize that thE product table is not normalized but we are restricted at the moment to importing daily from an image dB through DTS. we basically have to parse...

Sorry I had duplicates in my table.

yes. thank you for your patience and help.

not sure what i would do without this site.

-cm

basically i need to take a given shortsku, look it up in tblproduct, from there get the edp and join that to tblkit and from there get the componentedp(s). i...

Thanks,

table a is a product table that is maintained in our legacy system and then imported into sql. any of the data could be modified. i definitely will need...