Search results for query: *

My SSIS package has a Execute Process Task to unzip a file using WinZip This process has the following Executable: E:\Program Files (x86)\WinZip\WINZIP32.EXE Arguments: e -o -j E:\bi_loader_drop\myfile.zip E:\mydirectory This process has worked for years, now it hangs up. When I run the...

I am transferring a client to a new database server. I have reindexed the database. Is there a way to optimize the tables. Can I defrag the data pages some how?

I have a DTS package that use to display the raise error message when I double clicked on the failed step in the dialog box that displays when the job is executing This is a DTS package (not SSIS) that executes several stored procedures. Within these procedures, there are several custom...

I don't know exactly what your data looks like, but you may be getting duplicates due to the inner joins. I typed this up in notepad so the syntax may need to be tweaked. This may fix the duplication: SELECT Transactions.Date, C.Cust_ID, C.Cust_Name, Sum(Transactions.Sales) as Sales...

I think I will just download the page using a batch file with this tool: http://gnuwin32.sourceforge.net/packages/wget.htm Then... I can import the Index.html file with DTS, clean it up and evaluate what I need.

The page lists out like an FTP site, but is at an HTTP address. I am using sql 2000 DTS and when I try to use the FTP task, it says it cannot connect.

This is actually an FTP site. Ideally, I would like to capture the modified date of what displays on the FTP site. If that is not possible, is there any easy way to capture the modified date of a file using active X?

I have no idea how to approach this problem I have. Basically, there are four files on a web site. Any time they are replaced with new files, I need to download the files, run an import program and update a table with the new modified dates. The modified dates are stored on the web site. Is...

The test was in handwriting as I suspected. I don't remember all of the question and don't think I should dump someone else's test on the internet. Here are some good ones that may help others preparing for the same problem. It's not verbatim so I don't think it will do any harm. I was...

IN SQL SERVER you need aliases select * from (select 'a' a, 'b' b union select 'aa' a, 'bb' b) a cross join (select 'c' a, 'd' b union select 'cc' a, 'dd' b) b

I can tell you that the N'leeds' is converting the character string leads to data type nvarchar. Can't help you with the rest.

I know your getting that strange error, but does it have anything to do with the service account? When you execute SSIS via an agent job, it is running under the service account.

I can't help you to much with BCP since I have never used it. There is nothing wrong using BCP. Looks like your just looping through a cursor for the files and then running your BCP statement. Test it on a small subset and verify record counts.

Is the data type INT in the SQL table? Obviously that wont work. You may just have to change the data types. Right click on the data source and destination objects and choose advanced options then go to data types.

I would recommend looking at the advanced options of the source and destination. There are data types options in there too.

I think so. You can have error records re-direct into another table on import. Sounded like you wanted to do that. Using SSIS is also a bit more robust. You can set up a for each loop, put the file name into a variable and have the import loop through all of your text files. It also may be...

You could also look into using SSIS/DTS

Is the data returning rows were all counts are zero OR are you getting duplicates? I was thinking, you could add together all of the counts and evaluate to make sure total count is greater than zero. Then, you would be sure at least one row has a record count of one.

Anything helpful in this article? http://msdn.microsoft.com/en-us/library/aa172599(SQL.80).aspx

So you don't want client records with newopenings = 0 and futurepositions = 0 and totalorders = 0 reported? Why not include that in a WHERE clause? After the left join add WHERE a.newopenings <> 0 and a.futurepositions <> and a.totalorder <> 0 Not sure if you need to handle nulls?