what 's your naming convention when developing SSIS packages?
thanks in advance.
View Complete Post
Has Microsoft documented on the naming convention for windows and web controls like they did for Classes.
I'm looking for a Naming Convention /Best Practicies for the name of object generated in SSRS, such a TextBox, Group,...
(E.g. TextBox1-->TextBoxAccount or tbx_Account or Table, tableXXTextBoxAccount ??)
Doest anyone have a intersting link or could suggest me any naming convention ?
I am trying to define an advanced policy involving use of executeSql() function and @@SchemaName, @@ObjectName parameters. It is related to non-clustered index naming convention and as such I am making use of 'Index' facet. I have defined policies
for tables and procedures and I have successfully used executesql with @@SchemaName and @@ObjectName parameters. However, when I run Index policy I get the following error;
TITLE: Microsoft SQL Server Management Studio
Exception encountered while executing policy 'CompanyName - Index - Naming Convention'.
For help, click:
Must declare the scalar variable "@@SchemaName". (Microsoft SQL Server, Error: 137)
For help, click:
I've seen many posts on this topic. Unfortunately I haven't found a solution for a very specific naming convention that I'm hoping there is a solution for. Codeless perferably but either way. The naming convention is as such H3-RFR-KED-MRC-1
The H3-RFR- is static. The "KED" & "MRC" are both pulled from 2 seperate drop down lists in the form which describe the path of a workflow. The "1" is the @ID, looked up from the sharepoint site. The issue I have is number increases sequentialy,
regardlessof the path. Ideally I'd like the naming to follow as such . . .
Where each new 'path' combination would start at 1, but if the path is not unique the number increases by the max total of that combination +1. Is this at all possible? if so can someone point out where I can find that solution.
We look at some techniques you can adopt to reduce the amount of housekeeping code you write so you can focus on the essence of the application.
MSDN Magazine February 2009
Learn what the different parts of an assembly name mean, how to create a stronly named assembly, and get other assembly security tips.
MSDN Magazine August 2003
Hello, just wanted to ask a question about SSIS and SharePoint, any input will be greatly appreciated.... did search the forum but could not find anything....
So basically we have a SQL Server DB with the metadata ONLY, WITHOUT the related files(doc/ppt/pdf..etc) which should've been in the DB and they are on a separate web server inside folders. Each row in the DB has a key (column) which matches the related
folder's name, so for row with ID #112, there's a folder named ID112 on the web server with the relevant files inside. There could be more than 8+ files for one folder.
Now, I think it is possible but just wanted to double check, would it be possible to use SSIS and some kind of a script to get the metadata inside the SQL DB AND the related files inside those folders, combine & relate them and
upload them into SharePoint as a custom list with file attachments? would they display the attachment normally (like the paperclip icon in a sharepoint list...etc) I wonder if anyone has tried this...
Any guidance, thoughts, suggestions for other solutions, inputs will be great!!! Thank you!!