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 ...
Hi,
I am using BCP to export SQL table to CSV and it works great. but it doesn't include the header - Column name. I need to include it ;-(
Below is my T-SQL.
Thanks!
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 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 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...
Experts,
I am using SQL Server 2005, which I just started using last week, with no formal training. I do have some experience with SQL Server 2000, however. I was named as the backup to t...
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
When I run a openrowset in T-SQL I recieve this error:
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)"
I am trying to open a text file...
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...
I have a CSV with three columns that I want to import into an SQL table. Upon importing, I need to add an ID column to my flat file data set that increments the next ID number that already ex...
Hi,
We are using SQL Server 2005, and I like to know how can I deploy a SSIS.dtsx package on the server and schedule the job to run the package?
Thanks,
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...
Hi,
Does anyone know what the syntax is to alter to IDENTITY column so that the new starting number can be changed?
I have tried:
ALTER TABLE CONTACTSOURCE
ALTER COLUMN LOAD_ID IDEN...
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. ...
So I have two identical SQL 2005 databases, one on server #1 which is the back-end for my Production site, and one on server #2 which is the back-end Training site. I have had a number of new...
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...
Hi,
Can anyone please tell me how to import text file in SQL 2005 64bit using BCP utility?
Thanks
Hi,, I'm trying to use a left outer join along with an inner join,,,
Select CMRC_Categories.CategoryName,cmrc_products.productID,modelname,active,unitcost,listprice,thumbnail, longdesc, eve...
Hello All,
What I'm trying to accomplish.
Execute a sql statement
Take query results, and create a new excel file.
Within the VB Script define the name and path of the file, using ...
HI,
I'd like to execute some sql in my SSIS package and store the result in a package variable. Should be simple you would have thought.
I have the following syntax in my Exec Sql Task s...
I have a SQL Server 2005 database hosted with a third party. I want to create a copy of the whole database, including schema, data, stored procedures - everything. This copy is to be used loca...
Hi all
In SSIS, I am trying to parse together a string (hard-coded) and an double (column) as another column, with this expression:
"Debits are " + [debits] +", and credits are" + [cre...
I have an Execute SQL Task in a DTS package. It executes a SQL Stored Procedure, which returns a string value. I want to set a global variable to that value. I tried the code below but get an ...
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:
----------------------------------...
On a Windows 2003 server there are mutliple errors in the event log as seen below. If I open component services under administrative tools then expand Computers, the My Computer icon has a red...
