Viewing 15 posts - 61 through 75 (of 132 total)
I don't know the answer. Maybe ask in the Integration Services forum. I used to do that with DTS, set up a variable in the package and pass...
March 29, 2012 at 1:06 pm
Yes, obviously they should tell you.
Thanks. I wanted confirmation before sending my sarcastic email to the sys admins. They all good folks and friends, just averse to communication....
March 29, 2012 at 12:59 pm
My task is to monitor a folder and when a XLSX file appears import the data into an SQL table, a few hours later a new file will appear with...
March 29, 2012 at 10:19 am
Yes, you should be able to use an SSIS package to import your spreadsheet data. You'll need to call the 32-bit DTS runtime from within your stored procedure to...
March 29, 2012 at 9:52 am
I've adapted your code into a regular VB.Net Script Task.
Nice. I think I'll do the same!
I looked there in the begining. But not knowing anything about .NET, I...
December 29, 2011 at 8:20 am
I need to get rid of this first row (the faux header created by the T-SQL task) before I send everything to the customer. Any thoughts?
I've been playing around with...
December 22, 2011 at 12:43 pm
We have lots of sql servers here (only the 1 binary). Plenty of places this database could move to.
But I'll do the search and check it out.
December 16, 2011 at 3:15 pm
Well... that's not going to happen. Too many opportunities for a mistake. The app in front of this database imports text data and formats paychecks for laser printing....
December 16, 2011 at 3:00 pm
In your linked server script you have @provstr=N'DSN=SOTAMAS90'
Is this a DSN that lives on the DB server?
And when you use your laptop, that DSN can't be found?...
November 30, 2011 at 1:57 pm
Or deliver Ola Hallengren's Maintenance Solution. Give them defrag and CheckDB along with backup jobs.
November 23, 2011 at 1:23 pm
Create a job in the SQL Server Agent. The Agent is a job scheduler.
November 23, 2011 at 1:13 pm
Why don't you deliver an agent backup job that calls a delivered backup stored procedure. Both can be scirpted.
Have the variables involved (db name, backup destination folder, etc...) passed...
November 23, 2011 at 1:07 pm
For a single table:
select * from table where 1=2
Lists just the column names in the result panel. Is that what you meant by headers?
November 23, 2011 at 12:52 pm
Try adding an output file on the advanced form of your job. Maybe it will reveal a clue. Or try running the script via xp_cmdshell while in query...
November 18, 2011 at 9:54 am
BUT, if you have already experienced problems with the file import, then you must delete the flat file connection and then create a new instance, otherwise no matter what you...
October 25, 2011 at 9:16 am
Viewing 15 posts - 61 through 75 (of 132 total)