I have a File Connection Manager which is used by SSIS logging. The File Connection Manager is set to "Create File" and the path for the file is set by a variable. However when I run the package it creates a folder with the name of the file instead of the file itself. For example c:\ssisLogging\Log.txt Log.tx would be listed as a folder not a file.Mr Shaw

Hi Mr Shaw, Configure the File Connection Manager Editor to CREATE FILE Option. Below link will help you understand more on this. http://msdn.microsoft.com/en-us/library/ms137955.aspx Thanks, Guru

What is being passed to the variable, did you make sure it is c:\ssisLogging\Log.txt? The variable must be assigned to the Connection String property of the Flat File Connection ManagerArthur My Blog

Hi Mr Shaw, Configure the File Connection Manager Editor to CREATE FILE Option. Below link will help you understand more on this. http://msdn.microsoft.com/en-us/library/ms137955.aspx Thanks, Guru The FileUsageType already eqauls 1Mr Shaw

What is being passed to the variable, did you make sure it is c:\ssisLogging\Log.txt? The variable must be assigned to the Connection String property of the Flat File Connection Manager Arthur My Blog I have set the expression for connection string to: @[User::filePath] + "SSISLogging\\acceptanceTestLog.txt"Mr Shaw

It definitely sounds like the File Usage Type is set to CREATE FOLDER - perhaps this is being set by an Expression too? In the Properties window, this value should be 1 for FileUsageType (3 is CREATE FOLDER).every day is a school day My Blog

It definitely sounds like the File Usage Type is set to CREATE FOLDER - perhaps this is being set by an Expression too? In the Properties window, this value should be 1 for FileUsageType (3 is CREATE FOLDER). every day is a school day My Blog There is only one expression set on this object.Mr Shaw

It definitely sounds like the File Usage Type is set to CREATE FOLDER - perhaps this is being set by an Expression too? In the Properties window, this value should be 1 for FileUsageType (3 is CREATE FOLDER). every day is a school day My Blog It works when I delete the txt file. However, if I specify a new path it creates a directory not a file.Mr Shaw

What version are you running? I can't repro on: Microsoft SQL Server 2008 (SP2) - 10.0.4000.0 (Intel X86) every day is a school day My Blog

The path contains an extra \ why? Do you set the path (conn string) variable using an expression? Can you dump your variable's content to a message box to examine what it is?Arthur My Blog

The path contains an extra \ why? Do you set the path (conn string) variable using an expression? Can you dump your variable's content to a message box to examine what it is? Arthur My Blog Because you have to use \\ in an expression. It translates into \ at run time.Mr Shaw

The path contains an extra \ why? Do you set the path (conn string) variable using an expression? Can you dump your variable's content to a message box to examine what it is? Arthur My Blog Msgbox is a good idea... i'll try it.Mr Shaw

What version are you running? I can't repro on: Microsoft SQL Server 2008 (SP2) - 10.0.4000.0 (Intel X86) every day is a school day My Blog I am using SQL 2005Mr Shaw

Not in Conn Manager, but in your flat file destination, you probably have the Override property set to False. You need True.Arthur My Blog

I am not familar with the Override propery. Where to do i set the Override value?Mr Shaw

You can access it by clicking on your Flat File Destination and then in the properties window at the bottom you should be able to see it. Let me know if that has fixed your issue.Arthur My Blog