Name Flat file at run time

Hi,

I create a flat file in my package using Dataflow task and then I need to send that text file on some FTP site but the problem I am facing is I need to generate file name at run time like file name should be like "abc.yymmdd.txt" where yymmdd are Year,month and date.

Is there any way to give name to a flat file?

Thanks,

Pooja

your Connection Manager has a Property Collection called Expressions. Expand that, and set the ConnectionString to a variable expression.|||

"ABC." + (DT_WSTR,8) ( (YEAR(@.[User:ateTimeVar]) * 10000) + (MONTH(@.[User:ateTimeVar]) * 100) + DAY(@.[User:ateTimeVar]) ) + ".TXT"

Change the variable reference (@.[User:ateTimeVar]) to GETDATE() if you want today's date to be used.

sql

MySql SSIS Hangs with ODBC Drivers

Hi, we are writting a SQL Server Integration Services package to import data from a MySql database to a Sql Database.

We are using ODBC 3.51 Drivers to connect to the MySql Database in SSIS. The package runs perfectly in design mode. When we schedule the package to run, the package seems to hang about 1/3 of the times.

What can this be. We used to the package and ran it from a Sql Server 2005 to a Sql Server 2005 database. This setup works perfectly. When i'm doing MySql to Sql Server 2005, 1/3 of the times, it does not work.

Can anyone help me with this?

Giovan Gentile
Ayuda Media Systems

Implementation of ODBC is different by different vendors and for each different data source (after all, that was the goal of it). Therefore because an ODBC connection works fine with a particular source database is no guarantee an ODBC connection against a different database will work for your purposes- _the implementation code is totally different_.

Also, allowing implicit data type conversions (in my experience) is often the source of problems in moving data between different RDBMS implementations. Create views in the source to explicitly make any data type conversions required for the Sql Server destination. That can only help...

Ken

|||

Hello Ken,

Importing from mySQL with the 3.51 works fine for me.

Does your package "hangs" on big resulsets specifically ? If so, it could be that your datasource in configured to cache results from mySQL before making them available to the consumer. That's the default behavior.

Turning on "Allow big results" and "Don't cache result (forward cursor only)" options at the ODBC datasource level fixed the pb for me.

Hope it helps.

--

Jerome

my SQL cant open window when installation

Is there anyone can help me to run window when after done with installation, i wana open but i got message" this installation package could not be opened. verify that the package exists and that you can access it. or contact the application vedor to verify that this is a valid Windows Installer package"
My comp is running w/ Win home XP.
thanks

I have installed the Eval Enterprise edition in XP home but I think you can only install personal edition in XP home, so I would check the edition you are installing. Hope this helps.

My package does not take the values configured in the configuration file.

Hi all,

I created a simple file system task to copy a file from one location to another on my local system.

I used variables to specify the source and destination paths and now in my configuration file if I configure the values to something else also the package is taking the initial default values and not the values specified in the configuration file.

Can anyone throw some light on this.

Thanks in advance.

first of all check that u are using configutaion file in your package correclty

second check that variable is being mapped (present) in your configuration

these are all i can assume from ur explained scenario

write back to me if u find ne luck

regards,

Anas

|||Also, look at the execution log of the package; a warningis generated each time a configuration does not take place. If you are executing it via BIDS, go to the progress tab; otherwise enable package logging.