SSIS and Import/Export (2005) | Forum profile

> usually the key that we use for time dimension will represent the date itself i.e like 20090121 for 21.1.2009

> i think what you need is data flow task with oledb source containing your query and access connection for destination.

> Hi May be its useful http://blog.sqlauthority.com/2008/08/23/sql-server -2008-configure-database-mail-send-email-from-sql- database/ http://www.databasejournal.com/features/mssql/arti cle.php/3646986/SQL-Server-2005-Integration-Servic es---Part-39---Send-Mail-Task.htm ------------------------- R...

> Hi Goto success line(component connector its shows green arrow) double click that there you can find expression you can put @cnt>0 ------------------------- R...

> quote: it basically times out and doesn't finish. That doesn't make sense. Do you get a time-out error? What is the command you are using? Are you using the command-line version of winzip? Is it possible the command is waiting for user input? But you don't see that screen.

> If you have "use database_name" in the first line of the query, remove it, then the problem should be solved.

> quote: Originally posted by Starlet_GT To zip a file do the following in "Execute Process Task". In Process Tab: In Executable: C:\Program Files\WinZip\WINZIP32.EXE In Arguments: -min -a "C:\file.zip" "C:\file.mdb" I completely understand this, but what if your input file (i.e. C:\file.mdb) is a variable (i.e. c:\file_mar_2009.mdb). How do you supply the...

> isnt it enough to execute sp in sql and then pump results onto excel?

> you can use ftp task to get files onto your folder. then use for each loop to loop through files and use dataflow task to transfer data using flat file source and oledb destination to get data onto table.