Hi,
I am working on MS-SQL 2005,
Like in MS-SQL we can directly import the Excel file into the table of database using wizard
Is there is anyway in MS-SQL-2005, where we can import the ...
I would really appreciate if anyone would let me know what are the equivalent datatypes in Oracle 10g for the following SQL Server 2000 datatypes:
uniqueidentifier (16)
nvarchar (16)
nvar...
Hi
I'm trying to get a SSIS package to run from a sql server agent job but it won't becase I heep getting the below error. I can run the package manually but it won't run from a job and I g...
Hi,
I have a stored procedure on SQL Server 2000 that I would like to run from Excel.
The sp doesn't return any data to the excel spreadsheet it just updates tables on the SQL Server whi...
I have created a DTS Package in SQL the runs a query and creates an Excel file with that data. I would like to be able to create the file with some basic formatting (column widths, row height...
I have a massive text file with consultant data for my company that I have to synchronize with records in SQL 2005. The text file uses ~ as the column delimiter and carriage returns for the r...
Hi All,
I have a flat file that contains 2 types of records - Awards and Remptions. The Awards will be noted with an A and the Redemptions with a R. These records are different - The awar...
We are using: SQL Server 2000 DTS....
I am trying to import 3 csv files into a table, each spreadsheet contains that years invoices. So there is 2007revenue, 2008revenue.csv, 2009revenue.c...
Exporting a 300+ table SQL file from SQL to Access using SQL Server 2005 (SP2)
Execution produces the following errors at the Preparing to Execute stage:
----------------------------------...
Running Sql Server 2000 on SBS 2003 premium fully patched.
I have a fairly large text file filled with comma delimited data. I need to read it as fast as possible.
I am not an fso expert....
I had some DTS packages that I had used the migration tool in SQL 2005 to convert into DTSX. However I am not able to see the any of the DTSX files in my SQL 2005 Server. So what I am trying...
Is there a function that pad leading zeros in activex?
Hi SSIS Experts,
I have a dataflow task that creates a text file and posts it in a FTP share.
In need to rename the file attaching datestamp(current date of package execution) at the end o...
I have a ms sql 2005 SSIS package with an execute SQL task running a stored procedure. Initially the sp had no parms and I got the package working correctly.
I have now changed the sp to ac...
Using SQL Server 2000 and DTS.
I created and populated an ADO recordset using ActiveX script. Data is not coming from any tables or queries.
How can the recordset data be transferred to Ex...
I'm attempting to update existing records that are already in a SQL database through an Active X Script in SQL using VBScript. I do not want to add new records, I only want to update specific ...
Hello experts:
I need help with exporting data from SQL tables to a text file. What I am trying to achieve is this:
--First of all these are huge sql tables (5-8GB)
--I want export data as...
I'm exporting using a query to a flat .txt file. The problem I'm encountering is when I export the data and then open the .txt file into excel some columns cause line breaks to the next row. ...
Okay, I'm reposting this because I never got an answer and I REALLY an answer to this. Please help.
_____________________________________________________________________________________'
...
I am trying to write a SQL Server 2000 DTS package that will pull down a file using SQL Server's "FTP TASK". The catch is... the file that I am trying to pull down has a filename that is based...
I am transferring data from an AS400 to a SQL table via DTS. The fields that contain date values on the AS400 are stored on the 400 in numeric format, for example 112106 for November 21st, 20...
Hi,
I have a "foreach loop" in the control flow and have an "excel source" in data flow. I like to know how can I pass different excel file name to the connection string?
Here are the st...
I have written an application which programatically imports data from an Access database into a SQL Server database using DTS. The program runs correctly on my own computer but when I run it f...
Im using the SQL Server Import and Export Wizard that comes with SSIS. The data source is ibm's 'IBM OLE DB Provider for DB2'. I believe the MappingFiles that it should be using is 'IBMDB2To...
I have the following code in a stored procedure called by a DTS Execute SQL Task:
-----------------------------------------------------
-- Error handler for Errors encountered
ErrorHandler:...
