Set Location 'SQL Server' and save it in your target sql server instead of structure file.
Just in case, did you check the file path exits in the server?
Hi, When you used the wizard to create the dts package, did you use the transfer object option?
Hi, you dont need anything in your timberline server. Timberline database -> db1 SQL database -> db2 you have Timberline ODBC driver in SQL Server...
Hi, Yes, it's better. Good remark.
Hi,<br />so you have to select some data_num depend on the web page the user is.<br /><br />then you need to know what data_num you have to select...
Hi, Read these articles, maybe they help you to take a decision. http://www.dmreview.com/article_sub.cfm?articleId=5251...
Hi, Your data_visibility table 25047State1 25147City1 25247Address0 25347Zip_code0 The query SELECT d_vis.data_name,...
Hi,<br /><br />your SP seems to be ok with the information you give. I see only one problem.<br />If default value for one Data_num is changed then...
Hi, I see for your example that you have this situation: TableA (userid, name) 001 John 002 Karen 003 pomela TableB (userid, permissionid) 001 A...
Hi,<br /><br />I agree with mmarovic, why do the life hard when there is not reason?<br /><br />You can do a dts to import a text file with just two...
Hi, If exists(Select * from table) is usually used to know if the table is empty or not. EXITS function only returns TRUE or NOT TRUE values and it...
Hi,<br /><br />I think is better readable in this way,<br /><br />SELECT <br /> [t1].[id], <br /> [t1].[claim_id], <br /> [stage_dscp] = <br...
Hi all, You will get the same performance with both queries since: - EXITS just check for nonempty set and internally return either TRUE and NOT...
Hi, If the package uses a special task created by the vendor, this task should be registered in your computer otherwise you could receive a error....
Hi, Do you do any type of transformation with the data during the process or just use copy column transformation?. Are you using datapump task or...
Hi, Have you checked the connections in the disconnected properties option of the package? U will be able to see all package's connections and their...
Hi all, You could use this approach: (this is valid as long as you use SQL 2000) Main tables (where you will insert productive data) Table_January...
Hi all, You could use this too. SELECT RIGHT('000000' & CAST(field_name as char(6)),6) or SELECT RIGHT('000000' & CAST(COALESCE(field_name,0) as...
Separate names with a comma.
