Search results for query: *

Here is the Code we were using to merge multiple csv files with same format in to one Csv file How can I make use of this code in ssis or how can I rewrite it to perform the same function. Thanks for the help in advance. Dim sFilename As String Dim PathName As String Dim...

Hi, I created a SSIS package to export data from SQL query to Excel I had to do data conversion to get rid of the converion errors str to unicode datatypes. I used OLDB detination with extended property as 8.0 because my excel destination is MicroSoft Excel 97-2000 Can anyone please help me...

Iam sorry to reply you back after a long time. There was a little confusion but it is cleared. Thank you

One more question, Does that mean the user should 'sa' previlages?

Thank you Denny

Can a user with fixed database role given sql authentication to connect to the sql server schedule jobs by any means. Thank you

Have you tried setting the password inthe excel spread sheet(in tool right mouse and select protection and then select the options required).

Hello everyOne, I have Dts packages on SQL Server 2000 Devloper edition I can't Schedule the packages that load the data from files on the windows server or generates reports onthe server but i can schedule the package if it has to do something with in the SQL server databases. can any one...

Hi everybody, what is the eqivalent datatype in T-SQL for the datatype double (8) i have a field that stores money with datatype decimal(13,2) which i will have to export to a >DAt file as double(8). any help on this thanks

Hi there, need Help on this I have a DTS package which creates two excel files with filedate extension. (i get file date from inputfile ). i used active X for creating the XLS files (i did not select the Excel connection icon from the task bar) the problem is if i have to rerun the file...

Thank you Gragi, the script is very useful may be ican check all the files in the source folder with all the files inthe destination folder in 'FOR LOOP'. and if any is matched exist else continue. Iam using your script for my other packages that needed the above logic. thans once again

I have a Package which can process any number of files and after processing each file it Archives the Processed file in the Archive Folder. I cannot reprocess/Import the same file again(in case by mistake) to avoid this i need to put a check before each run to check the archive folder with the...

i will try this Thank you so much Alex

Please help me I have a DTS package with ActiveXScript that can process any number of files(CSV files) but the logic in the SQLcode inside the package needs the files to be processd in an order by the name of the file,example say i have 3 files-- (left 8 digits in the file name is the actual...