Wednesday, March 7, 2012
Cannot take Backup in Tape..............Why ? what is wrong with this tape?
I haver very weird problem. I have installed BackupExec for Windows on our S
taging Server. It run goods with our Backup jobs but when i go to SQL Server
and try to backup and database on tape. It gives me this error :
The media family on device '\\.'Tape0' is incorrectly formed. SQL Server can
not process this media family.
BACKUP DATABASE is terminating abnormally.
What could be wrong ?
What can i do to make my backup run on Tape.
P.S
Tape is DELL (Media Recognition System) 20 GB.
System is Dell PowerEdge.
Thanks for any response
Abid MalikChange \\.Tape0 to
\\.\Tape0 ( you are missing a whack!)
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Abid Malik" <abidmunirmalik@.hotmail.com> wrote in message
news:9859C468-C59D-45FD-A045-D1EAE4BE61BF@.microsoft.com...
> Hi there.
> I haver very weird problem. I have installed BackupExec for Windows on our
Staging Server. It run goods with our Backup jobs but when i go to SQL
Server and try to backup and database on tape. It gives me this error :
> The media family on device '\\.'Tape0' is incorrectly formed. SQL Server
cannot process this media family.
> BACKUP DATABASE is terminating abnormally.
> What could be wrong ?
> What can i do to make my backup run on Tape.
> P.S
> Tape is DELL (Media Recognition System) 20 GB.
> System is Dell PowerEdge.
>
> Thanks for any response
> Abid Malik
>
Sunday, February 19, 2012
Cannot Set Connection String For Bulk Insert Source Connection
I came across something strange today. I was wondering I was doing something wrong.
I want to go through a directory and get files and assign the Fully Qualified File Name to a User Variable. I want to use that variable as a connection string within Expression in Bulk Insert Task Source Connection, Data Flow Task and File System Task. It is working fine within Data Flow Task and File System task. It is NOT working for Bulk Insert. Did you come across this or am I doing something wrong?
- Expressions
ConnectionString @.[User::FileName]
Did anyone come across this before?
Thanks
Sutha
Seems to be a problem to me, it does not work within the context of a for each loop, keep getting the error message, connection not valid.
I have written this script and placed it into an activex task before the bulk insert, this seems to fix it.
Dim connmgr As ConnectionManager = Dts.Connections("[your connection name]")
connmgr.ConnectionString = Dts.Variables("User::filename").Value.ToString()
connmgr.AcquireConnection(Nothing)
Hope this helps !
Mark|||
Cheers Mark. It does work fine. I put a script task inside Foreach, just before Bulk Insert to set the connections.
Still thinks its a Bug. Anyone from MS can confirm it. If so do you want me to raise a Bug for this?
Thanks for your help
Sutha
|||Hello Sutha,
I am trying to achieve the same. Can you help me.
Foreach loop container is reading all the files in the specified folder.
I can also read the variable. But I am having difficulties in assiging this variable file name to Bulk Insert, connection, Source connection.
thanks & regards
radha.
|||I could not reproduce this issue.1. I could set the value of the "SourceConnection" property to the name of the connection I want to use in my bulk insert task and it works.
2. I can also assign the value of the "ConnectionString" property of the connection to a variable that points to the file and it works.
|||
I am having same issue:
Simple package: Foreach Loop, inside ForEach Loop is a Bulk Insert Task.
I set the variable User::FileName in the variable Mappings of the Foreach Loop. I create a FlatFile connection in connection manager and go into the Expressions of the flat file connection and set the ConnectionString to be @.[User::FileName]. I set the connection in the Bulk Insert to be the Flat file connection I created and I run the package... I get the error: "The specified connection "XYZ Files" is either not valid, or points to an invalid object. To continue, specify a valid connection." Its very reproduceable.
Been fighting with this all day... can someone post step-by-step how to do the workaround where the script sets the connection?
|||Dim connmgr As ConnectionManager = Dts.Connections("Name of Flat File Conn Manager")connmgr.ConnectionString = Dts.Variables("Var Name of Full path and filename").Value.ToString()
connmgr.AcquireConnection(Nothing)|||See this link for a Dec 27 Blog. http://denster.spaces.live.com/
Cannot Set Connection String For Bulk Insert Source Connection
I came across something strange today. I was wondering I was doing something wrong.
I want to go through a directory and get files and assign the Fully Qualified File Name to a User Variable. I want to use that variable as a connection string within Expression in Bulk Insert Task Source Connection, Data Flow Task and File System Task. It is working fine within Data Flow Task and File System task. It is NOT working for Bulk Insert. Did you come across this or am I doing something wrong?
- Expressions
ConnectionString @.[User::FileName]
Did anyone come across this before?
Thanks
Sutha
Seems to be a problem to me, it does not work within the context of a for each loop, keep getting the error message, connection not valid.
I have written this script and placed it into an activex task before the bulk insert, this seems to fix it.
Dim connmgr As ConnectionManager = Dts.Connections("[your connection name]")
connmgr.ConnectionString = Dts.Variables("User::filename").Value.ToString()
connmgr.AcquireConnection(Nothing)
Hope this helps !
Mark|||
Cheers Mark. It does work fine. I put a script task inside Foreach, just before Bulk Insert to set the connections.
Still thinks its a Bug. Anyone from MS can confirm it. If so do you want me to raise a Bug for this?
Thanks for your help
Sutha
|||Hello Sutha,
I am trying to achieve the same. Can you help me.
Foreach loop container is reading all the files in the specified folder.
I can also read the variable. But I am having difficulties in assiging this variable file name to Bulk Insert, connection, Source connection.
thanks & regards
radha.
|||I could not reproduce this issue.1. I could set the value of the "SourceConnection" property to the name of the connection I want to use in my bulk insert task and it works.
2. I can also assign the value of the "ConnectionString" property of the connection to a variable that points to the file and it works.
|||
I am having same issue:
Simple package: Foreach Loop, inside ForEach Loop is a Bulk Insert Task.
I set the variable User::FileName in the variable Mappings of the Foreach Loop. I create a FlatFile connection in connection manager and go into the Expressions of the flat file connection and set the ConnectionString to be @.[User::FileName]. I set the connection in the Bulk Insert to be the Flat file connection I created and I run the package... I get the error: "The specified connection "XYZ Files" is either not valid, or points to an invalid object. To continue, specify a valid connection." Its very reproduceable.
Been fighting with this all day... can someone post step-by-step how to do the workaround where the script sets the connection?
|||Dim connmgr As ConnectionManager = Dts.Connections("Name of Flat File Conn Manager")connmgr.ConnectionString = Dts.Variables("Var Name of Full path and filename").Value.ToString()
connmgr.AcquireConnection(Nothing)|||See this link for a Dec 27 Blog. http://denster.spaces.live.com/
Cannot Set Connection String For Bulk Insert Source Connection
I came across something strange today. I was wondering I was doing something wrong.
I want to go through a directory and get files and assign the Fully Qualified File Name to a User Variable. I want to use that variable as a connection string within Expression in Bulk Insert Task Source Connection, Data Flow Task and File System Task. It is working fine within Data Flow Task and File System task. It is NOT working for Bulk Insert. Did you come across this or am I doing something wrong?
- Expressions
ConnectionString @.[User::FileName]
Did anyone come across this before?
Thanks
Sutha
Seems to be a problem to me, it does not work within the context of a for each loop, keep getting the error message, connection not valid.
I have written this script and placed it into an activex task before the bulk insert, this seems to fix it.
Dim connmgr As ConnectionManager = Dts.Connections("[your connection name]")
connmgr.ConnectionString = Dts.Variables("User::filename").Value.ToString()
connmgr.AcquireConnection(Nothing)
Hope this helps !
Mark|||
Cheers Mark. It does work fine. I put a script task inside Foreach, just before Bulk Insert to set the connections.
Still thinks its a Bug. Anyone from MS can confirm it. If so do you want me to raise a Bug for this?
Thanks for your help
Sutha
|||Hello Sutha,
I am trying to achieve the same. Can you help me.
Foreach loop container is reading all the files in the specified folder.
I can also read the variable. But I am having difficulties in assiging this variable file name to Bulk Insert, connection, Source connection.
thanks & regards
radha.
|||I could not reproducethis issue.
1. I could set the value of the "SourceConnection" property to
the name of the connection I want to use in my bulk insert task and it
works.
2. I can also assign the value of the "ConnectionString" property of the connection to a variable that points to the file and it works.
|||
I am having same issue:
Simple package: Foreach Loop, inside ForEach Loop is a Bulk Insert Task.
I set the variable User::FileName in the variable Mappings of the Foreach Loop. I create a FlatFile connection in connection manager and go into the Expressions of the flat file connection and set the ConnectionString to be @.[User::FileName]. I set the connection in the Bulk Insert to be the Flat file connection I created and I run the package... I get the error: "The specified connection "XYZ Files" is either not valid, or points to an invalid object. To continue, specify a valid connection." Its very reproduceable.
Been fighting with this all day... can someone post step-by-step how to do the workaround where the script sets the connection?
|||Dim connmgr As ConnectionManager = Dts.Connections("Name of Flat File Conn Manager")connmgr.ConnectionString = Dts.Variables("Var Name of Full path and filename").Value.ToString()
connmgr.AcquireConnection(Nothing)|||See this link for a Dec 27 Blog. http://denster.spaces.live.com/
Cannot Set Connection String For Bulk Insert Source Connection
I came across something strange today. I was wondering I was doing something wrong.
I want to go through a directory and get files and assign the Fully Qualified File Name to a User Variable. I want to use that variable as a connection string within Expression in Bulk Insert Task Source Connection, Data Flow Task and File System Task. It is working fine within Data Flow Task and File System task. It is NOT working for Bulk Insert. Did you come across this or am I doing something wrong?
- Expressions
ConnectionString @.[User::FileName]
Did anyone come across this before?
Thanks
Sutha
Seems to be a problem to me, it does not work within the context of a for each loop, keep getting the error message, connection not valid.
I have written this script and placed it into an activex task before the bulk insert, this seems to fix it.
Dim connmgr As ConnectionManager = Dts.Connections("[your connection name]")
connmgr.ConnectionString = Dts.Variables("User::filename").Value.ToString()
connmgr.AcquireConnection(Nothing)
Hope this helps !
Mark|||
Cheers Mark. It does work fine. I put a script task inside Foreach, just before Bulk Insert to set the connections.
Still thinks its a Bug. Anyone from MS can confirm it. If so do you want me to raise a Bug for this?
Thanks for your help
Sutha
|||Hello Sutha,
I am trying to achieve the same. Can you help me.
Foreach loop container is reading all the files in the specified folder.
I can also read the variable. But I am having difficulties in assiging this variable file name to Bulk Insert, connection, Source connection.
thanks & regards
radha.
|||I could not reproducethis issue.
1. I could set the value of the "SourceConnection" property to
the name of the connection I want to use in my bulk insert task and it
works.
2. I can also assign the value of the "ConnectionString" property of the connection to a variable that points to the file and it works.
|||
I am having same issue:
Simple package: Foreach Loop, inside ForEach Loop is a Bulk Insert Task.
I set the variable User::FileName in the variable Mappings of the Foreach Loop. I create a FlatFile connection in connection manager and go into the Expressions of the flat file connection and set the ConnectionString to be @.[User::FileName]. I set the connection in the Bulk Insert to be the Flat file connection I created and I run the package... I get the error: "The specified connection "XYZ Files" is either not valid, or points to an invalid object. To continue, specify a valid connection." Its very reproduceable.
Been fighting with this all day... can someone post step-by-step how to do the workaround where the script sets the connection?
|||Dim connmgr As ConnectionManager = Dts.Connections("Name of Flat File Conn Manager")connmgr.ConnectionString = Dts.Variables("Var Name of Full path and filename").Value.ToString()
connmgr.AcquireConnection(Nothing)|||See this link for a Dec 27 Blog. http://denster.spaces.live.com/
Cannot Set Connection String For Bulk Insert Source Connection
I came across something strange today. I was wondering I was doing something wrong.
I want to go through a directory and get files and assign the Fully Qualified File Name to a User Variable. I want to use that variable as a connection string within Expression in Bulk Insert Task Source Connection, Data Flow Task and File System Task. It is working fine within Data Flow Task and File System task. It is NOT working for Bulk Insert. Did you come across this or am I doing something wrong?
- Expressions
ConnectionString @.[User::FileName]
Did anyone come across this before?
Thanks
Sutha
Seems to be a problem to me, it does not work within the context of a for each loop, keep getting the error message, connection not valid.
I have written this script and placed it into an activex task before the bulk insert, this seems to fix it.
Dim connmgr As ConnectionManager = Dts.Connections("[your connection name]")
connmgr.ConnectionString = Dts.Variables("User::filename").Value.ToString()
connmgr.AcquireConnection(Nothing)
Hope this helps !
Mark|||
Cheers Mark. It does work fine. I put a script task inside Foreach, just before Bulk Insert to set the connections.
Still thinks its a Bug. Anyone from MS can confirm it. If so do you want me to raise a Bug for this?
Thanks for your help
Sutha
|||Hello Sutha,
I am trying to achieve the same. Can you help me.
Foreach loop container is reading all the files in the specified folder.
I can also read the variable. But I am having difficulties in assiging this variable file name to Bulk Insert, connection, Source connection.
thanks & regards
radha.
|||I could not reproduce this issue.1. I could set the value of the "SourceConnection" property to the name of the connection I want to use in my bulk insert task and it works.
2. I can also assign the value of the "ConnectionString" property of the connection to a variable that points to the file and it works.
|||
I am having same issue:
Simple package: Foreach Loop, inside ForEach Loop is a Bulk Insert Task.
I set the variable User::FileName in the variable Mappings of the Foreach Loop. I create a FlatFile connection in connection manager and go into the Expressions of the flat file connection and set the ConnectionString to be @.[User::FileName]. I set the connection in the Bulk Insert to be the Flat file connection I created and I run the package... I get the error: "The specified connection "XYZ Files" is either not valid, or points to an invalid object. To continue, specify a valid connection." Its very reproduceable.
Been fighting with this all day... can someone post step-by-step how to do the workaround where the script sets the connection?
|||Dim connmgr As ConnectionManager = Dts.Connections("Name of Flat File Conn Manager")connmgr.ConnectionString = Dts.Variables("Var Name of Full path and filename").Value.ToString()
connmgr.AcquireConnection(Nothing)|||See this link for a Dec 27 Blog. http://denster.spaces.live.com/
Thursday, February 16, 2012
Cannot select Provider in Data Source Wizard Connection Manager
I try to create a New Data Source in Data Model project, the dropdown box for
Provider is disabled and so SQLclient Data Provider is all I can do. I would
like to add a connection to an ODBC data source, which I should be able to
do. Any suggestions on what I can change to enable me to select the Provider?Semantic modelling in Model Designer supports native SQL provider only.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Shane_SDE" <ShaneSDE@.discussions.microsoft.com> wrote in message
news:054075DE-92DF-4127-9B53-0DB5FEB43670@.microsoft.com...
>I think I either have an option set wrong or installed something wrong.
>When
> I try to create a New Data Source in Data Model project, the dropdown box
> for
> Provider is disabled and so SQLclient Data Provider is all I can do. I
> would
> like to add a connection to an ODBC data source, which I should be able to
> do. Any suggestions on what I can change to enable me to select the
> Provider?