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!
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 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 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
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 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 an SSIS script task that builds up a variable that is a SQL server statement. I need ot be able to execute that statement in the script task.
Here is the code I have
...
I've finished with a fairly large database that is ready to go into production. The database is built on SQL Server 2005 Express edition on a development server. I connect to the production SQ...
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...
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...
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...
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...
hi
i created a web app with sql server 2005 express edition
when i kept that for hosted the server has sql 2008 so it shows wrong connection string and that server owner is duffer he dont k...
How to generate SQL script to DROP all triggers
How to generate SQL script to CREATE all triggers
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. ...
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...
could you please let me know how i could deploy the package and schedule it to run as part of the SQL jobs
Hi all, can someone tell me how to copy and Excel worksheet to a new workbook and keep the format. When I do it, I lose all of my formatting and have to tell it to reformat. I am doing this ...
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 am running sql server 2005, all the database backups are fine. I have around 20 automated jobs running in the sql server agent. Does anybody know how to back these up? At the moment t...
I have a very single package, with a delete sql statement
Then a Data Flow
Inside dataflow, there is an oledb source to read all the files from a table.
Then I have 2 fuzzy lookups, t...
I have three (3) tables:
a. Products with fields Id, SKU, ProdName, Category
b. ProductInventory with fields QtyOnHand and ProductId (a FK from table Products)
c. InvUpdate -- this is ...
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 data in a column called State each state is inside double quotes such as "Maine"
and I want to remove the double quotes so that it is just Maine without double qoutes.
How do I ...
