I have a business partner with FTP access to our server. He has his system set to automatically FTP a CSV data file to our server. I need to read this file periodically and import or update ...
I have a SQL Server 2000 DTS package that pushes data to the AS400. The package runs perfectly when run manually. When the package is run as a scheduled task on the server, it fails and logs...
Hello All,
We have a few databases of around 12 GB which are on MS SQL 2000. We are wanting to upgrade the database server to avoid the End of life issues with MS SQL 2000. Here are my ques...
I'd like to ask you for some recommendations for SQL server 2000 DTS packages on SQL 2005/2008 platform.
There is MSIS technology of course, but it looks a bit young to me for using in indust...
Hi i have some 5 txt files and 2 xls file.
I want to create a data warehouse .
After that need to do the transformation, saying fileA we will receive daily and fileB we receive in a w...
Hi
I am connecting to both access and sql server databases. I want to use the same select statement however i am having problems with the differences in UCase() and Upper(). Any ideas of...
I am a beginner when it comes to using SQL but have just recently discovered DTS Packages to do imports and schedule them, which is great for me as I have lots of updates/imports I do each day...
hi,
i need some dts activex script help to do the following:
check if the file exist
if file exist continue the rest of the dts
if not don't execute the rest of the dts
I want to unzip files using SSIS package:
I have browsed many blogs before asking this question. I have little blurred picture of what I am supposed to do.
1.Use executable process task....
have a table set up with a trigger to set the date and time of a colum called last_modified
When I import the data into the blank table, the trigger does not fire, my table is populated bu...
(SQLServer2005 SSIS 2005 MSVisual Studio 2005)
I've got a dtsx package which imports an xml file into several tables which works fine in BIDS. I need to run this from a stored procedure us...
I have multiple files in multiple folders and I need to recurse across the files importing the cells / rows in c4:g16 from an excel file into a sqlserver 2000 table.
I am open to BCP/sqlser...
I'm looking for a way where when my backups are done. I'm looking online and will continue to do so. Thanks
Hi all, I am trying to do the following, but it doesn't seem to like it, gives me an error near '='..... reason I am doing this the way I am is because the CJ_BranchID could be null, so I am ...
I receive the following error when trying to parse a SQL statement in DTS. A parse of the same statement in Query Analyzer completes successfully.
Error:
Error source: Microsoft OLE DB...
I need to add a second condition to a query but am unable to find the correct syntax. The condition is that the "CountofREG_HR" must be greater than 14. I have tried entering it after the Wh...
hi folks
i restored a BAK file from a server to my local MSSQL 2005. the restoreseemed to go ok, but the database still says "<DBNAME> (restoring...) " in the database list.
what can be...
Hi,
We are unable to Find Row Deliminator of attached dat file, the Extension is changed to .txt you can rename it to .dat
Our Aim is to Write an SQL Procedure to Upload multiple .dat file...
I am trying to copy data from one server to another. I guess one cannot use two different database names in an INSERT statement?
Running SBS2003 domain server with a separate Windows 2000 ...
I have 20 of the same stored procs in both our UAT and PROD environments. I need to create csv files from all these stored procs and compare UAT and PROD csv's for differences. I already have ...
Hello
I've inherited a set of sql tables that are riddled with <script> tags. Is there a quick way to remove them from each table with some kind of global replace?
I have a DTS which runs a stored proc into output csv file. The stored proc has one parameter which causes different data to be retrieved. I would like to execute this stored proc multiple tim...
I have end users running SQL Server 2008 Developer Edition. Some are still running SQL Server 2000 Enterprise for the client view on there computers. How can I disable there access from viewin...
Hi all, I am getting the following error with my code:
Operation is not allowed when the object is open
I am trying to do an insert based on one PriEquip with several AuxEquip
I have a SQL 2000 DTS Package which has 3 tasks (database connection, transform data, text file connection. There is a global variable which is used as a parameter for the transform data task...
