Viewing 15 posts - 25,711 through 25,725 (of 26,487 total)
Two things. One, I don't know your zip program so you will have to read the help files for it to figure how to use it. Second, we really have...
July 5, 2007 at 10:21 am
This may also be a good time to explore upgrading to SQL Server 2005 where you can actually store XML data using the new XML data type.
July 5, 2007 at 9:07 am
Thought I'd check and see how your zip process is coming. I will take a bit of time and work on the next two pieces of your puzzle for renaming...
July 5, 2007 at 8:17 am
That is one you will have to play with, just like I did with our zip utility. That is one reason I like SSIS, I can disable all the other tasks...
July 3, 2007 at 4:51 pm
Opps. Almost forgot, you will need a script task as well. This will run before the file system task.
![]()
July 3, 2007 at 2:47 pm
You now need a Sequential Container (actually you don't but it makes things easier). Connect your Data Flow task to this container such that this container (and its contents) execute...
July 3, 2007 at 2:42 pm
I will throw this one thought out to you. You are trying to change from a Case Sensitive collation to a Case Insensitive collation. In this database, you have at...
July 3, 2007 at 2:18 pm
I'd change directions a bit. One, is there a network share on the server that you can access from your desktop and the server using a UNC (\\Servername\Directory[\SubDirectory ...]? ...
July 3, 2007 at 1:58 pm
I assume that you hardcoded the filename and destition. This package will eventually run on the server, correct?
July 3, 2007 at 1:50 pm
First, quick question, what did you name the file and where are you putting it (okay, actually two questions).
![]()
July 3, 2007 at 1:30 pm
I think the easiest way to work you through this is a step at a time. I was trying to list all the steps you need to complete, but I...
July 3, 2007 at 11:18 am
Does this mean that CurrentDate is like this: 2007-07-01 13:03:01.133?
Not familiar with 7-zip, does it have a command line capability?
![]()
July 3, 2007 at 10:26 am
Two questions I need answered first. One, what is the format of the date in Created? Two, what software are you going to use to zip the output file?
We are...
July 3, 2007 at 10:14 am
Try this against your sample data:
select
item,
vendor,
sum(case when year(entered_date) = 2005 then sales else 0 end) as TotalSales2005,
sum(case when year(entered_date) = 2006 then sales else 0 end)...
July 3, 2007 at 9:42 am
Unfortunately, I can't see your sample data. If you can post it as a series of insert statements that could be cut and pasted like your table DDL, that would...
July 3, 2007 at 9:25 am
Viewing 15 posts - 25,711 through 25,725 (of 26,487 total)