Viewing 15 posts - 16 through 30 (of 65 total)
Well, most of the time BOL doesn't help me and I dislike most of the examples they give. My habit now days is to just open up google. ...
May 19, 2014 at 3:14 pm
Right now I'm using SSMS but when I get everything put together, I'm going to throw the script into an SSIS package and put it on a schedule.
BULK INSERT dbo.daily_pmts
FROM...
May 15, 2014 at 1:07 pm
dwain.c (10/21/2013)
WITH SampleData AS
(
SELECT invoice_no
FROM
...
October 21, 2013 at 6:35 pm
Because I pulled the data into a temporary table from the main db, this script wasn't working. I figured out that because I took the data as is, the...
October 21, 2013 at 4:12 pm
Thank you both for your suggestions. I most truly appreciate the feedback.
I now have a working SSIS package.
Here's what I did in a nutshell for anyone that may find...
September 9, 2013 at 3:47 pm
I don't think this is going to help but just in case, these are screenshots of the package in it's entirety....
August 7, 2013 at 3:52 pm
Koen Verbeeck (8/7/2013)
100% sure the source is pointing to the correct server?Any package configurations?
I'm 100% positive it's pointing to the right server. I even double checked after reading your...
August 7, 2013 at 3:32 pm
Koen Verbeeck (8/7/2013)
Is there anything in the package configured to redirect rows by error or truncation?
No I don't. It's a pretty simple SSIS package. It has an OLE...
August 7, 2013 at 2:31 pm
I'm not really a .Net programmer so I can't go that route. I do understand short and simple C# and VB scripts but I know more python and ruby...
March 6, 2013 at 9:36 am
Never mind. I found this post and tweaked a few of my settings on my SSIS package and I was able to rename the file to a static name...
February 6, 2013 at 4:26 pm
I tried using SELECT @@ROWCOUNT and I can't get it to work with an automated data pull on a schedule. I was trying to use COMPUTE as a suggestion...
July 6, 2011 at 3:03 pm
Elliott Whitlow (5/16/2011)
May 16, 2011 at 5:12 pm
Actually Excel isn't the format that they need it in. Our AP people will only open that file momentarily to make sure the amounts tie to a report in...
May 16, 2011 at 4:42 pm
Trying to get schedule the package to run on the reports server gives me the following...
Message
Executed as user: REPORTS\SYSTEM. ...ion 9.00.5000.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All...
May 13, 2011 at 5:09 pm
Sorry, I've had to drop this project to work on others but now I'm not back at it. Here are a few more observations...
SSIS tasks that allow me to...
June 24, 2010 at 12:55 pm
Viewing 15 posts - 16 through 30 (of 65 total)